Create query that shows stories and open tasks for each story

[Andy Stengel]

For a specific project, component and status

[Alexey Matveev · Accepted solution]

Hello,

You can not do it out of the box. Have a look at the ScriptRunner plugin:

https://scriptrunner.adaptavist.com/latest/jira/jql-functions.html#_linkedissuesof

[Andy Stengel]

Yes, I am using the ScriptRunner Plugin. I cant seem to get both the stories and subtasks working on one query though.

[Alexey Matveev]

It would be like this

issuetype = Story or issueFunction in subtasksOf("issuetype = Story and status = Open")

[Andy Stengel]

Thank you!!

[Alexey Matveev]

You are welcome! If my answer helped you, Kindly accept my answer. In this case other people with a similar question will be able to find this answer.

[sudhakar]

Hi 

We can get open stories and open tasks for the stories using  JQL Search Extensions plugin 

Query :  ((subTaskStatus = "Open" AND issuetype = Story) OR (parentStatus = "Open" AND parentIssueType = Story ))

Above qury gives us list of stories and sub-task which are in open status .

https://jqlsearchextensions.atlassian.net/wiki/spaces/SEARCH/pages/3375124/JQL+Reference+Cloud#JQLReference(Cloud)-SubtaskStatus

Regards

Sudhakar