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

Annamaija Viik March 18, 2024

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.

3 answers

2 votes
Stephen Wright _Elabor8_
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
March 18, 2024

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

0 votes
Sachin Dhamale
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
March 19, 2024

@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 @Stephen Wright _Elabor8_  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.

 

0 votes
Hannes Obweger - JXL for Jira
Marketplace Partner
Marketplace Partners provide apps and integrations available on the Atlassian Marketplace that extend the power of Atlassian products.
March 18, 2024

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:

number-of-subtasks-zero.gif

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

Suggest an answer

Log in or Sign up to answer