Filter Subtasks Where Parent Task Is a Certain Issue Type

I would like to create a filter that will return the following results:

Project: ABC
Issue Type: Sub-task
Issue Type of Parent Task: XYZ

Using the JQL Tricks Plugin (or OOTB JIRA capabilities), is there a way to accomplish this?

1 answer

1 accepted

4 votes
Accepted answer
  • Hi Lana,
  • if you have jql tricks plugin try this one
  • project="ABC" AND issuetype=Sub-task AND issue in parent("issuetype=XYZ")

If I helped you please remember to mark my answer wink


My apologies. I should have added that I've tried this, but am getting an error at character 67, which I'm assuming is related to my use of quotes:

project = "Client Services Projects" AND parent in ("issuetype = "MRC Task"")

Unfortunately, any combination of quotes that I try are giving me: 
Error in the JQL Query: Expecting ',' or ')' but got 'MRC'

Try this:

project = 'Client Services Projects' AND issue in parent ("issuetype = 'MRC Task'")

or.... choose issutype which is single word for try wink

project = 'Client Services Projects' AND issue in parent ("issuetype = Task")


If that will work we will go further wink

Getting closer! smile  When I try that, I get the following error: 
The issue key 'issuetype = MRC Task' for field 'parent' is invalid.

I've also tried the query with an issue type of Task (which is a valid issue type for the project) and got the same error (but with 'Task' instead of 'MRC Task' in the error).

project = 'Client Services Projects' AND issue in parent("issuetype = Task")

remember about issue in parent not just parent

I overlooked that part of the query... that worked! 

Here's the query I used in the end: 
project = 'Client Services Projects' AND issue in parent ("issuetype = 'MRC Task'")

Thank you so much for your help, Michal!

Hehe smile I am glad to help. If you will have sth in the future let me know.

Is there a way to get exactly the same result but with a variable and a comparison? To be precise:

For a specific issue type we want to have only the sub-tasks of this specific issue type and no others.

So a query could look like this: 

issue in parent ("issuetype = 'valueofcustomfield'") and customfield = Meeting XY

Where Meeting XY is supposed to be equal to the valueofcustomfield to be shown. The subtask did inherit the the value of the issuetype to the customfield before from the parent. 

I hope this was understandable smile

Thanks for any advice!


Is there a way to do this without using the JIRA Tricks plugin? We use a cloud instance

Like 4 people like this

Also interested

Like 1 person likes this
Like 1 person likes this

Also interested, using cloud instance..

Like 1 person likes this

Suggest an answer

Log in or Sign up to answer
Community showcase
Published 15 hours ago in Jira

How you can achieve compact and easy-to-maintain workflows in your JIRA( Server)

This approach requires you to have the JIRA administrative rights. The main aim of this article is to help you achieve an organized, easy-to-maintain workflows in your JIRA instance thereby, reducin...

148 views 0 0
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you