查询/过滤以从活动父母(EPIC)列表中返回孩子问题 [英] Query/filter to return child issues from a list of active parents (EPICs)

查看:117
本文介绍了查询/过滤以从活动父母(EPIC)列表中返回孩子问题的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

我正在寻找一个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屋!

查看全文
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆