Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Next challenges

Recent achievements

  • Global
  • Personal


  • Give kudos
  • Received
  • Given


  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

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?

2 answers

1 accepted

6 votes
Answer accepted
  • 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 # people like this

Also interested

Like # people like this
Like # people like this

Also interested, using cloud instance..

Like # people like this

Also interested

Like Jesse Vetsch likes this

Also interested in cloud instance

Also interested (cloud instance)

Also need a solution that works on cloud solution

Hi @Michal Partyka 

Your solution does not work for me

"project="ABC" AND issuetype=Sub-task AND issue in parent("issuetype=XYZ")"  

Now I can not get the option of parent after issue in, could you please suggest any alternative. 

My scrum board should also show the sub-tasks created in a story and these sub-tasks should automatically display on the scrum board.

Looking forward your solution.




Also interested in cloud instance solution

Like # people like this

Ok, the problem is with an add-on is many people work in a company that does NOT allow users to download or install add-ons without a huge issue and at least 6 months of red tape.   Oh and if you can't justify it as saving a significant amount of money then you can't get your request high enough in the queue to ever be reviewed.  


Typed on a small screen so forgive the spelling and grammar

Like Vegar Hatlevik likes this

This is what I need.  Though I have Jira Cloud.  Any similar free options?

I am trying to do something pretty simple.  I am trying to get a list of all open subtasks in a given version (the subtasks, do not have a version, but the parents do)

Like Sergii Kryshtop likes this

Is there any free alternative for this?

According to the marketplace information, Sweetbananas plugin is only free on the trial month.


thanks in advance

For cloud:

JQL searchextensions plug in (sorry it's not free, and I'm just a user, not the dev)

parentIssueType in (

works great.

Suggest an answer

Log in or Sign up to answer

Community Events

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

Find an event

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

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you