Dear Sir or Madam, I am not sure if this is the right topic. I have not found any JQL-related topic that is why I post it in the general "Jira"-topic. we are using quick-filters for the kanban-board in Jira. In 1 quick-filter we want to see * only the tasks which have a specific component. We have a quick-filter which uses this JQL code: 'component = ' * and we would like to see all sub-tasks of these tasks. Something like 'parent has (component = ) AND type = SubTask' would be nice to have - is there any JQL-code which can do this job and display also the sub-tasks which have a (super-)task which has a specific component? Thanks in advance Joel

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

JQL-Command to filter out a sub-task with a parent-task with a specific component

Joel Hofer

Dear Sir or Madam,

I am not sure if this is the right topic. I have not found any JQL-related topic that is why I post it in the general "Jira"-topic.

we are using quick-filters for the kanban-board in Jira. In 1 quick-filter we want to see

only the tasks which have a specific component. We have a quick-filter which uses this JQL code: 'component = <component-name>'
and we would like to see all sub-tasks of these tasks. Something like 'parent has (component = <component-name>) AND type = SubTask' would be nice to have - is there any JQL-code which can do this job and display also the sub-tasks which have a (super-)task which has a specific component?

Thanks in advance

Joel

Accepted answers

Joel Hofer

The working JQL is:

Component = "<component name>" or issueFunction in subtasksOf('component = "<component name>"')

So, when you want to check a component of a super-task (meaning you are looking at a sub-task of a story) you need this code:

issueFunction in subtasksOf('component = "<component name>"')

Shalom

Joel

All comments

Jack Brickey

Hi Joel, welcome to the Community. OOTB there isn’t a JQL to achieve your goal. However, what about placing the component into the Subtask? This would allow the following to work...

component = xxxx and type = sub-task

if this won’t work consider an addon, e.g. Scripting that has JQL functions that could meet your needs.

Joel Hofer

The working JQL is:

Component = "<component name>" or issueFunction in subtasksOf('component = "<component name>"')

So, when you want to check a component of a super-task (meaning you are looking at a sub-task of a story) you need this code:

issueFunction in subtasksOf('component = "<component name>"')

Shalom

Joel

Megha Sinha

This query works in On-Premise but not on cloud, any leads?

Jack Brickey

@Megha Sinha , so that query requires Scriptrunner. Are you using scriptrunner in cloud?

Megha Sinha

No, we are not using script runner, Are there any alternatives

Daniel Turczanski - JQL Search Extensions

Hi @Joel Hofer ,

@Megha Sinhaasks how to get the same results in Jira Cloud. 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. Your use case is more dynamic than that.

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

JQL Search Extensions

After you install the app, you can simply search:

component = "<component name>" OR issue in subtasksOfParentsInQuery("component = '<component name>'")

Make sure the check out the documentation.

I hope this helps!

Joshi_b8tehl

Not working, sub queries are not working in JIRA anymore

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira