JQL for counting SubTasks

[Katalin Váradi]

Hi guys,

I am looking for a JQL to filter issues that have more than two SubTasks.

Is it possible to filter issues based on the number of their SubTasks without any add-on, plugin or script?

Thank you in advance.

[Prosper Agwegiokhe · Accepted solution]

Hi @Katalin Váradi ,

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

The app I work for, JQL Search Extensions for Jira, you can use the query below to find issue by the count of their subtasks.

E.g:

subtasksCount > 2

The query above will return issues that have more than 2 subtasks.

You can see more information about this query here, and please contact our support if you have any other questions about this query.

We’ll be happy to help you!

Best regards,
Prosper.

[Ravina · Accepted solution]

Hi @Katalin Váradi There is no default way in JQL to get the Sub-tasks count in jira without the help of script,plugin.

[Katalin Váradi]

That's pity. Thanks for the quick help.
By the way, what are the other options with script or plugin?

[Hannes Obweger - JXL for Jira]

Hi @Katalin Váradi

welcome to the community!

If you're open to solutions from the Atlassian Marketplace, I think you might like the app that my team and I are working on, 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 long list 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 your smart columns, and also use them across JXL's advanced features, such as support for (configurable) issue hierarchies, issue grouping by any issue field(s), sum-ups, or conditional formatting.

Once you've narrowed down your list of issues, you can work on your issues directly in JXL, trigger various operations in Jira, or export your issues with just one click.

Any questions just let me know,

Best,

Hannes