JQL search for linked sub task issues

Question

I don't think Jira has this function natively but want to know if there's an add on that will do this or if this exact function is available in Jira 8.0

Example of the search would like to be able to do:

In Project Taco, search for all STORY issues, that have the reporter of TAllen, that also have CLOSED Sub Tasks tickets linked to those STORY issues.

I would only want to see the sub-tasks issues in the results if possible. If not having the Story ticket within the results is fine as well but not ideal.

Is a search like that even possibly with an add on? I'm trying to create a filter that would notify the Reporter on the STORY issues when a linked Sub-Tasks issue has been closed/updated.

Thomas Schlegel · Accepted Answer

Hi @Jeremy Price ,

with plain Jira this JQL is not possible. Using Scriptrunner, you can do the following:

issueFunction in subtasksOf("issuetype = story and reporter = TAllen") AND issuetype in subTaskIssueTypes() AND status in (<your closed status>)

Tarun Sapra · Accepted Answer

Hello @Jeremy Price

Your requirement can easily be implemented by the Script runner plugin's JQL functions

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

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

But your description seems ambiguous.

You have mentioned " In Project Taco, search for all STORY issues"

And then you say "I would only want to see the sub-tasks issues in the results if possibl"

Do you want to see stories in search result or sub-task and can you please elaborate once more exactly what you want.