JQL for Stories without Sub-Tasks

Brandon Ivey

I would like to run a search for all story issue types with sub-tasks attached AND (specifically) without sub-tasks attached. I do not have the "issue function" ability nor script runner. I have tried to run it by parent/child and linked type as well, no dice. Can anyone help me write a query that doesn't use script runner or have the "issue function"? Thank you so much!

Trudy P Claspill

Hello @Brandon Ivey 

With native Jira search functionality it is not possible to construct a filter to find issue based on whether or not they have subtasks.

If you are not open to getting a third party app to extend the searching capabilities, an alternative would be to create a custom number field to hold the count of subtasks an issue has, and use automation to set the field.

You could have the field automatically set to 0 for each newly created issue, or leave the field empty initially.

You could then have an automation that is triggered each time an issue is created. If the issue is a Subtask, then retrieve its parent, count the number of subtasks it has, and update the "count of subtasks" custom field.

You could write an automation that would process all currently existing issues to populate the field with current information.