How to show with JQL list of features which doesn't have any sub tasks under them?

[Annamaija Viik]

Hi!

I would like to create a filter with JQL, which gives me a list of features which doesn't have any sub tasks under them. How  I could do it?

Thanks for any help.

[Ste Wright]

Hi @Annamaija Viik 

What level are Features at in your hierarchy?

This isn't possible with native JQL - but you can do it using an App which extends JQL's functionality.

Do you have any of those Apps? Such as Scriptrunner, or JQL Search Extensions for Jira?

You can see a list of them on the Marketplace, see: https://marketplace.atlassian.com/search?hosting=dataCenter&product=jira&query=jql

Ste

[Sachin Dhamale]

@Annamaija Viik ,

By default this feature is not available in jira you need to go for some Third Party plugin to get that functionality like @Ste Wright  mentioned

If you don't want to go for third party plugin then

You need to keep count of subtask in the text or number custom field on issue level and use that custom field in the JQL to filter out the issue which has "0" in that custom field to get required result. You can do this through automation rule.

[Hannes Obweger - JXL for Jira]

Hi @Annamaija Viik

in native Jira, the only thing I can think of is to use Jira Automation to write the number of sub-tasks into a custom field and then filter based on this custom field, but I can't advice on the details.

As Stephen said, the easiest thing might be to consider a solution from the Atlassian Marketplace. If this is an option for you, my team and I work on an app in which your use case would be trivial to solve: JXL for Jira.

JXL is a full-fledged spreadsheet/table view for your issues that allows viewing, inline-editing, sorting, and filtering by all your issue fields, much like you’d do in e.g. Excel or Google Sheets. It also comes with a number of so-called smart columns that aren’t natively available, including the number of sub-tasks.

This is how it looks in action:

As you can see above, you can easily sort and filter by the number of sub-tasks, and also use it across JXL's advanced features, such as support for (configurable) issue hierarchies, issue grouping by any issue field(s), sum-ups, or conditional formatting.

This all just works - there's no scripting whatsoever required.

Any questions just let me know,

Best,

Hannes