Can I list out all the parent tickets which don't have any subtask?

[Moneruzzaman Rana]

I actually need a list of sub-tasks and those parent tasks where there is no sub-tasks. Is there any way to figure out with JQL without not using any extension? 

[Hannes Obweger - JXL for Jira]

Hi @Moneruzzaman Rana,

to the best of my knowledge, this isn't available out-of-the-box. You might be able to set up a rule in Automation for Jira that write the number of subtasks into a custom field, and then query by this custom field. I'm not a big Automation expert myself, so someone else will have to lean in for the details.

I understand that you prefer not to use a Marketplace app for this, but just for reference, there would be several options available. Just as an example, this would be trivial to do using the app that my team and I are working on, JXL for Jira:

As said above, there'll be several other options, too. You may already know that you can trial any app for free for 1 month, and depending on the size of your size, it may be free forever.

Best,

Hannes

[Sanjog Sigdel]

Hello @Moneruzzaman Rana 

Welcome to the group. I am using Jira Cloud and it doesnot support the issuefuntion() and its available custom commands. In Jira Server instance I would use the following query:

issuetype = "Story" AND issueFunction not in subtasksOf("")

As this is not available I simply dump tickets using the jira query in issue navigator. Then I add the Sub-tasks column.

Not I will sort the sub-tasks columns. It will display the tickets which has empty sub-tasks for me. This way I can use it further in excel or perform bulk edit.

You can also try Jira Automation to get this done.