查询/过滤以从活动父母(EPIC)列表中返回孩子问题 [英] Query/filter to return child issues from a list of active parents (EPICs)
问题描述
我正在寻找一个JQL查询/过滤器,以从活动父母(EPIC)列表中返回子问题列表.
I'm looking for a JQL query/filter to return a list of child issues from a list of active parents (EPICs).
例如:
"Epic Link" IN linkedIssuesInQuery("issueType = Epic AND Status = 'In Progress'")
我希望上面的查询可以工作,但是结果不是我期望的.标准JIRA(无插件)中是否有方法返回查询/过滤器集的所有子问题的列表?
I was hoping the above query would work, but the results are not what I expected. Is there a way in standard JIRA (no plugin) to return a list of all child issues of a Query/Filter set?
我也尝试过过滤器,但结果与上面相同:
I also tried a filter, but the results were the same as above:
"Epic Link" IN linkedIssuesInFilter("1234")
// Where Filter Id 1234 was something like => issueType = Epic AND Status = 'In Progress'
以上两个示例均返回结果,但是它们似乎是不完整的结果,我不明白为什么某些问题没有返回.
Both examples above return results, however they seem to be incomplete results and I don't understand why some issues not not being returned.
ps.函数 childIssuesOf("ABC-123")
返回单亲问题的正确结果,但是我如何提供动态的父母列表,而不仅仅是静态的硬编码问题编号?
ps. The function childIssuesOf("ABC-123")
returns the correct results for a single parent issue, but how do I provide a dynamic list of parents, not just a static hardcoded issue number?
编辑:经过更多的实验和阅读之后,我发现我正在使用的JIRA实例具有一个名为JQL Tricks的插件.该插件具有一个功能,基于其描述,正是我需要的功能: parent(JqlQuery)
...但它不起作用!
EDIT:
After a lot more experimenting and reading, I found that the JIRA instance I am using has a Plugin called JQL Tricks. This Plugin has a function which, based on its description, is exactly what I need: parent(JqlQuery)
... but it doesn't work!
这是我的测试查询:
issue in parent("project in (MyProject) and status = \"In Progress\" and issueType = EPIC")
此查询返回0条结果!但是,当我在 parent
中切出JqlQuery并单独运行它时,我得到了我希望看到的EPIC的完整列表,并且当我查看EPIC时,它们都有子问题.从我对该功能进行的所有实验中,我认为状态为进行中"(以及打开")存在问题,因为当我尝试使用其他状态类型进行呼叫时,子问题会按预期返回.我还尝试了一种用于进行中过滤的不同方法
This query returns 0 results! However when I cut out the JqlQuery within parent
and run it on its own, I get the complete list of EPIC's I expect to see and when I review the EPIC's they all have child issues. From all the experimenting I have done with this function, I believe there is an issue with the status "In Progress" (and also "Open") as when I try the call with other status types the child issues are return as expected. I have also tried a different approach for filtering for In Progress
issue in parent("project in (MyProject) and status not in (closed, refused, new, open) and issueType = EPIC")
但是结果与上面的结果完全相同,结果为0!最后,我还尝试了 subtask(JqlQuery)
函数,但也没有成功.
However the result is exactly the same as above, 0 results!
Finally I have also experimented with the function subtask(JqlQuery)
, also without success.
任何人都可以帮忙吗?
推荐答案
在 JQL技巧中, parent
和 subtask
JQL函数与父级一起使用/child(子任务)链接类型.您可能要搜索"Epic中的问题"链接类型,即使用"Epic Link"字段.
In JQL Tricks, parent
and subtask
JQL functions work with parent/child (subtask) link type. You might want to search for "issues in Epic" link type, i.e. using the "Epic Link" field.
使用JQL技巧,您可以尝试以下操作:
With JQL Tricks you can try this:
issue in issuesWhereEpicIn('project in (MyProject) AND status = "In Progress"')
来源: https://www.j-tricks.com/jql-tricks-plugin.html [1 , 2 ]
提示:(主要针对在此结束的其他用户找到相同的答案)
Tip: (mainly for other users ended here finding the same answer)
您还可以检查是否已安装 ScriptRunner 附件(也经常安装).您可以检查JQL中是否存在 issueFunction
).有了这个附加组件,您可以使用此:
You can also check if ScriptRunner add-on is installed (it's very often installed, too). You can check the presence if issueFunction
is available in JQL). With this add-on, you can use this:
issueFunction in issuesInEpics('project in (MyProject) AND status = "In Progress"')
这篇关于查询/过滤以从活动父母(EPIC)列表中返回孩子问题的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!