I have a JIRA filter which returns all the fixes in a future release:
project = MyProject AND fixVersion = "1.1.1" and issuetype in standardIssueTypes() and status != Closed
All of these issues have Sub-Tasks which I want to have in a new filter result. They do not have the fixVersion
set.
I have tried the parent
filter but this only accepts Key or ID.
Is there any way I can write a filter to access these without manually using something like parent in (MyProject-1,MyProject-2,MyProject-3,MyProject-4,etc)
?
I have a solution that requires no plugins whatsoever, but some manual work that is much better than listing the tasks in the query itself:
Using the linkedIssues function, you can write a query like so
parent in linkedIssues("PROJ-1061")
Now, link all the issues you want in this query to the PROJ-1061 and you're golden. You can do this in a bulk job, you can also add it as a trigger in a workflow potentially.
You can install the Craftforge JQL functions
https://plugins.atlassian.com/plugin/details/31601
You then create a filter
project = MyProject AND fixVersion = "1.1.1" and issuetype in standardIssueTypes() and status != Closed
Call this filter for example 'parentIssues'
Using the JQL
issue in subtaskIssuesFromFilter("parentIssues")
will retrieve all relevant subtask issues.
Use Script Runner plugin and a query like:
issueFunction in subtasksOf("project = MyProject AND fixVersion = 27_04_2013 and status != Closed"))
JQL Tricks adds tons of additional JQL functions: https://marketplace.atlassian.com/plugins/com.j-tricks.jql-plugin
Here an example for the above using their syntax:
issue in parent("project = MyProject AND fixVersion = 27_04_2013 and status != Closed")
There is no need for any Plugin.
Switch to "Advanced" filter option and enter
status in ("Open") AND parent in (PHX-xxx,ENG-xxx)
It will give you all the open tickets present as a subtask in parent JIRAs. Build more complex and enjoy using JIRA. Advanced filter options will also give you all possible values to build Queries.