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

Pupsen September 28, 2022

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?

3 answers

0 votes
mauricio.groth
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
September 29, 2022

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

0 votes
Trudy Claspill
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
September 28, 2022

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

Pupsen September 28, 2022

Thank you so much!

0 votes
Mark Segall
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
September 28, 2022

Hi @Pupsen and welcome to the community!

You want something like this:

project = YOURPROJECT AND (issueType != sub-task AND component IN ("One")) OR (issueType = sub-task AND (component IS EMPTY OR component IN ("One"))

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
FREE
TAGS
AUG Leaders

Atlassian Community Events