Need JQL Script to query Stories and get back subtasks

Blaine Shirk

I'm trying to write a JQL script that can return me all Stories with a specific Status AND return me ALL the associated Sub-Tasks linked to that story. 

The ideal behavior is that I could run this query and it would return to me all the Stories that have a status of (let's say "In Progress") and would also allow me to click on the Story in the Sprint Board and see all the associated sub-tasks (regardless of their status)

Jack Nolddor [Sweet Bananas]

Hi Blaine,

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, you can type the following:

 

1) Search all Stories with a specific Status (i.e. Open)

project = MyProject AND type = Story AND status = Open

2) Search for subtasks of "all Stories with a specific Status (i.e. Open)"

issue IN subtasksOf(' project = MyProject AND type = Story AND status = Open ')

3) All together

( project = MyProject AND type = Story AND status = Open ) OR ( issue IN subtasksOf(' project = MyProject AND type = Story AND status = Open ')  )

(*) 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