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?
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thank you so much!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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"))
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Online forums and learning are now in one easy-to-use experience.
By continuing, you accept the updated Community Terms of Use and acknowledge the Privacy Policy. Your public name, photo, and achievements may be publicly visible and available in search engines.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.