How do I pull a list of user stories with specific sub-tasks attached?

[Matthew Bright]

Hi, 

I am looking to pull a filter of all user stories with a specific sub-task assigned to it. In this case, any subtask that contains "QA" so i can track coverage. 

Does anyone have any experience creating this sort of filter?

Thanks

[Kristján Geir Mathiesen · Accepted solution]

Hi @Matthew Bright 

I believe this cannot be achieved in Jira out-of-the-box. If you have for example ScriptRunner, then this JQL should get the job done:

issueFunction in subtasksof("issuetype = \"Story\"") AND text ~ QA

HTH,
KGM

[Daniel Turczanski - JQL Search Extensions]

Hi

With standard JQL you can only get a list of issues and export them to Excel for further processing. This works if you want to do a one-off analysis. Your use case is more dynamic than that.

Standard JQL doesn't easily allow it but the results can be quickly found using our professional indexing service:

• JQL Search Extensions

After you install the app you can simply search:

Server/DC:

issue in parentOf("text ~ QA")

Cloud:

issue in parentsOfSubtasksInQuery("text ~ QA")

You may want to check out the docs as well.

I hope this helps!