Filter to show sub tasks of a filtered list of parent tasks

Question

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)?

Answer 1

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.

Answer 2

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.