JQL search for linked sub task issues

[Jeremy Price]

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.

[Tarun Sapra · Accepted solution]

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.

[Jeremy Price]

I would only want to see sub-task in the results, sorry for the confusion.

I would like to find the closed sub-task issues that are attached to any Story issues within a certain project and by a certain reporter on those Story tickets.

[Thomas Schlegel · Accepted solution]

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