JQL-Search: All subtasks and tasks without subtasks

[Silas Pohl]

Hello,

I want to filter all subtasks and tasks without subtasks.

I don't want to see the parent jiras of the subtasks in the kanban board.

What is the search prompt for this filter?

Thanks in advance

Greetings

Silas

[Charlotte Santos -Appfire-]

Hi @Silas Pohl 

I’m Charlotte, a support engineer at Appfire and I’m here to help you.

Unfortunately, using vanilla JQL, you’ll not be able to do it dynamically.

In the app where my team works, JQL Search Extensions for Jira, you can use this query to see all sub-tasks whose parent is a Task:

issue in subtasksOfParentsInQuery("type = Task")

And you can use this one to see all the Tasks that doesn’t have sub-tasks:

type = Task AND subtasksCount = 0

Please contact our support if you have any other questions about this query.

We’ll be happy to help you!

[Mayuresh Kamble]

Hi @Silas Pohl ,

Welcome to the Community!

I don't think this is possible natively in Jira. If you have Scriptrunner plugin you can use this query.

issueType = "Task" AND issueFunction not in hasSubtasks()

Regards,
Mayuresh

[Pierre Ibrahim]

Hi @Silas Pohl 

as @Charlotte Santos -Appfire- and @Mayuresh Kamble have already said, there's no all encompassing solution from Atlassian natively for your search, however if you have Scriptrunner installed, you can use the following JQL:

issuetype not in subTaskIssueTypes() and issueFunction not in parentsOf()

The "issueFunction  not in parentsOf()" is the only part requiring scriptrunner. As far as I'm aware "issuetype not in subTaskIssueTypes()" is native to JIRA.

So without scriptrunner you can get half way there.

Hope this helps!