(a.timeworked/3600/(cased.lower_parent_namewhen'org-pd-qa'then10when'org-pd-frontside-h5'then9when'org-pd-frontside-native'then5when'org-pd-serverside-b'then12when'org-pd-serverside-a'then7when'org-pd-product'then9else''end))aswminperm, date_format(a.STARTDATE,'%Y-%m-%d')assdate,...
借助强大的jql,我们可以在代码中构造需要的jql语句,查询自己需要的结果 例如,根据创建日期的范围来查询bug,那么jql如下 jql ="project in ({}) AND issuetype = 缺陷 AND created >= {} AND created <= {}".format(project, start_date,end_date) 获取不同sprint的故事卡数据 jql ="project in ({}) A...
1duedate < now() or duedate is empty NOT 個別の句、または括弧を使用した複雑な JQL クエリ (複数の句で構成されたクエリ) の否定に使用して、検索精度を高めることができます。 (注:NOT EQUALS("!=")、DOES NOT CONTAIN("!~")、NOT IN、IS NOTについてもご確認ください) ...
jql="project in ({}) AND issuetype = 缺陷 AND created >= {} AND created <= {}".format(project,start_date,end_date) 获取不同sprint的故事卡数据 代码语言:javascript 复制 jql="project in ({}) AND issuetype = Story AND Sprint in ({})".format(project,sprint) jql并不需要自己来写,在...
例如,根据创建日期的范围来查询bug,那么jql如下 jql = "project in ({}) AND issuetype = 缺陷 AND created >= {} AND created <= {}".format(project, start_date,end_date) 1. 获取不同sprint的故事卡数据 jql = "project in ({}) AND issuetype = Story AND Sprint in ({})".format(project...
the formatter and schema properties. JQL search aliases.1 2 jira:customField: - key: cf-type-money name: Development cost description: Tracks the development cost of features, in different currencies type: object formatter: expression: "`${value.amount} ${value.currency}`" schema: properties:...
Sprint.endDate is a automation smart value. You can't use it in JQLs. You can use the smart value condition and do something like this: {{issue.Sprint.endDate}} greater than {{now}} If above doesn't work, you might have to work a bit with the format. You read more about workin...
+1 whenever the target date field is changed. I'm not sure what should be the smart value i need to add in "Retarget no." an... 51 views 6 0 Fadi Shahwan yesterday Question data-center jira jira-automation jira-data-center smart-value Display Epic completion percentage on Jira ...
When was the due date changed? Which issues have new comments added last week? History searches with JQL With Jira Query Language, you can find a list of issues based on their values at a particular point in the past, instead of the current value of those fields. Advanced searches with ...
Create a queue for all unresolved requests shared with organizations that joined on 2023-08-24 where the date is in YYYY-MM-DD format: resolution = Unresolved AND Organizations in organizationDetail("Joined on", "2023-08-24") Consider a multi-select dropdown that can contain up to two valu...