Need Filter to show all subtasks assigned to me where the parent story is in a specific status.

[Eita_Harshman]

Need Filter to show all subtasks assigned to me where the parent story is in a specific status in the workflow.. 

[Jack Nolddor _Sweet Bananas_ · Accepted solution]

Hi Eita,

Sadly you cannot achieve the desired search using standard features on Jira, you must go for a third-party app instead. Using i.e. JQL Booster Pack if you are on Server / DataCenter or a similar app designed for Cloud you can type the following:

1) Search all subtasks assigned to me where the parent story is in 'Waiting' status

type = Subtask AND issue IN subtaskOf(' type = Story AND status = Waiting ')

(*) Note that this is just an example, you must tune above query to fit your needs.

Using this app you can also query other issues relations, check:

• epicsOf()
• hasSubtasks()
• issuesInEpics()
• linkedIssuesOf()
• parentsOf()
• portfolioChildOf()
• portfolioParentOf()
• subtasksOf()

References:

• Official documentation

[Eita_Harshman]

• I figured these would be the answered. Bummer. Thank you everyone for responding. I do appreciate it. 

[Mykenna Cepek]

I don't think Jira JQL supports that complexity (out-of-the-box) without installing (and likely paying for) an add-on App for Jira that expands the capabilities of JQL to traverse the issue hierarchy.

However, you may be able to visualize what you want without a strict filter to do that.

Consider a board with the "specific status" you desire mapped to a column on that board. Set the board to have swimlanes grouped by "Story". Then define a quickfilter on that board to show just your items (or limit the board filter to only show your items).

If you have permission to create a board in your instance, you can probably visualize on that board what you want, by customizing the board appropriately.

Let us know here what ended up working for you!

[Trudy Claspill]

Do you have an apps installed that extend the search functionality of JIRA, like Adaptavist ScriptRunner? Or are you limited to OTB functionality?