How to setup board filter where only parent issue has a certain component

Question

Hi everyone!

I have a case:

epic with component “One” and parent issues (story, bug, task) with a component “One”. I set up a board with the filter where issues should have component “One” => sub tasks without component are not displayed.

What query I should use to display epics and parent issues with component “One” and any component for sub tasks?

mauricio.groth · Answer

Hi @Pupsen

As you're on Jira Cloud, the correct answer is to get an app that provides JQL extensions you're looking for.

With standard JQL, you can only get a list of issues and export them to Excel for further processing. This works if you want to do a one-off analysis. If your use case is more dynamic than that, look beyond standard Jira.

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

You can use this query to display epics and parent issues with component “One” and any component for sub-tasks.

issue in parentsOfSubtasksInQuery("") and component = ONE or type = Epic and component = ONE

Check out the documentation for more examples.

If you have any other questions, please contact our support. We’ll be happy to help you!
Best regards,
Maurício

Pupsen · Answer

Thank you so much!

Trudy P Claspill · Answer

Hello @Pupsen

Welcome to the community.

With the Jira native functionality you will not be able to build a filter that will include sub-tasks only for the parent issues in your filter. If your current filter is

project=X and Component="One"

then you new filter would need to be something like

(project=X and Component="One) or issue in subtasksof(project=x and Component="One")

...and natively Jira does not have a function like "subtasksof".

You will need to add a third party app that extends the JQL capabilities, or add the "One" component to the sub-tasks.

There are several apps available that extend JQL capabilities. Some even remain free if your Jira instance stays below a set number of users.

https://marketplace.atlassian.com/search?hosting=cloud&product=jira&query=jql