A filter to show all tasks that contain a sub-task?

[Joe Milner-Smith]

I would like to create a filter to use on a dashboard gadget that will show all the tasks of a project that have a sub-task, and not show any tasks that don't have a sub-task. Is this possible?

[Sanjog Sigdel · Accepted solution]

Hi @Joe Milner-Smith

This is what I came up with real quick:

issuetype in subTaskIssueTypes() AND parent is not EMPTY 

This filter actually lists subtaks and in the next column of the filter results you can find the associated Tasks or stories. The result is all from simple jira queries.

But if you have the script runner enables in your jira app then below query will give you exactly you want.

issuetype = Task AND issueFunction in hasSubtasks()

[abhishek_sharma03]

Thanks @Sanjog Sigdel this is a good workaround, with parent issue in Summary column

[Joe Milner-Smith]

Thank you, this works for me :)

[Sanjog Sigdel]

Glad it helped.

@Joe Milner-Smith @abhishek_sharma03  You are welcome.

[abhishek_sharma03]

Hi @Joe Milner-Smith - Try 

project = ABCDE AND issuetype in (Task) and issueFunction in hasSubtasks()

However hasSubtasks() function is not native to Jira and is provided by Scriptrunner. As I understand this is only applicable for Jira server and DC.

BR

Abhishek