How to include subtasks for filtered issues in filter result

[Metod Bulovec]

I made a filter that filters based on a custom field named Billable, which is of type dropdown with multiple values.

My current simplified JQL is:

"Billable[Dropdown]" = Yes

This filter will currently display only User Stories and Tasks since only these issue types have a custom Billable field added.  I do not want to add my custom field to subtasks as well.

How can I write the JQL to include all subtasks for User stories or Tasks that were found by the filter?

I will then use this filter in Tempo to include only Billable User Stories and Tasks together with their subtasks in the report.

[Trudy Claspill · Accepted solution]

Jira does not natively provide a subquery feature, which is what you would need. You will need to look for a third party app that extends the JQL functionality.

One that I used before and liked was Adaptavist ScriptRunner, but there are several app available that could help you with this.

[Metod Bulovec]

Thank you, will look into the apps you suggested.

[Daniel Turczanski - JQL Search Extensions]

Hi @Metod Bulovec ,

Standard JQL doesn't easily allow it, but you can find the results quickly using our professional indexing service JQL Search Extensions.

After you install the app, you can simply search:

issue in childrenOfIssuesInQueryRecursive("'Billable[Dropdown]' = Yes")

Check out the documentation to see more examples.

I hope this helps!

Daniel