How to include subtasks for filtered issues in filter result

Metod Bulovec_doxsn7

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 P Claspill

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.