What is the JQL for issuetype = task or issuetype = subtask if parent = task?

Jonathan Smith

Morning everyone,

Ai is failing me today, so I am going to try to challenge the community with this one.

I have a large project which has multiple issue types.

In a filter, I want to show a desired issue type along with any sub tasks where the parent is the desired issue type.

Can someone assist me with this JQL?

Cheers,

Jonathan

 

Trudy P Claspill

Hello @Jonathan Smith 

That will not be possible with the native JQL capabilities.

You can create a filter such as this:

issue=ABC-123 or (parent=ABC-123 and issueType=Sub-task)

That filter will get you issue ABC-123 and all its sub-tasks.

What you want is this:

issueType=<yourType> or issue in subtasksOf(issueType=<yourType>)

Jira does not natively support getting a set of issues based on a dynamic list of another set of issues (the part in bold). To achieve that you will need a third party app that extends JQL capabilities, such as ScriptRunner Enhanced Search. Are you open to getting a third party app, or do you have such an app available to you already?