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

1. only the tasks which have a specific component. We have a quick-filter which uses this JQL code: 'component = <component-name>'
2. 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

[Joel Hofer · Accepted solution]

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

[Jack Brickey]

Can you articulate your precise goal? If it is exactly as specified by Joel then you cannot achieve OOTB. You will need some addon solution. I recommend continuing your search in the Community as well.

[Bruno Toni]

Tks @Joel Hofer 

This solution works for me!

[Nenad S.]

@Joel Hofer 

This works great - just what I needed

[Joshi]

Not working, sub queries are not working in JIRA anymore

[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!

[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.