Filter Subtasks Where Parent Task Is a Certain Issue Type

[Lana Wright]

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?

[Michael Partyka · Accepted solution]

• 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 

Michal

[Lana Wright]

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'

[Michael Partyka]

Try this:

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

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

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

If that will work we will go further 

[Lana Wright]

Getting closer!   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).

[Michael Partyka]

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

remember about issue in parent not just parent

[Lana Wright]

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!

[Michael Partyka]

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

[Deleted user]

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 

Thanks for any advice!

Christoph

[Grayson Bishop]

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

[Mark Gancsos]

Also interested

[Lucas_Del_Castanhel_Dias_-_TechnoPartner]

I am interested as well

[Jaspal Singh]

Also interested, using cloud instance..

[Jason Simon]

Also interested

[Nancy W]

Also interested in cloud instance

[Abidin Ali]

Also interested (cloud instance)

[ronny matthies]

Also need a solution that works on cloud solution

[rajesha2019]

Hi @ptychu 

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.

Thanks,

Rajesha

[Alberto García Ramos]

Also interested in cloud instance solution

[Simon Kälberer]

I use the free app JQL Booster with this syntax to solve this issue.

https://sweetbananas.atlassian.net/wiki/spaces/JBP/pages/774275101/subtasksOf

https://marketplace.atlassian.com/apps/1218367/jql-booster-pack?hosting=server&tab=overview

[Jason Simon]

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

[Raphi Levine]

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)

[Joao Santos]

Is there any free alternative for this?

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

thanks in advance

[W Bot]

For cloud:

https://marketplace.atlassian.com/apps/1214791/jql-search-extensions-for-jira-reports?hosting=cloud&tab=overview

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

parentIssueType in (

works great.