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

This widget could not be displayed.
  • 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


Michal

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!

Christoph

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

Suggest an answer

Log in or Sign up to answer
Atlassian Summit 2018

Meet the community IRL

Atlassian Summit is an excellent opportunity for in-person support, training, and networking.

Learn more
Community showcase
Posted Wednesday in New to Jira

Are you planning to trial, or are currently trialling Jira Software? - We want to talk to you!

Hello! I'm Rayen, a product manager at Atlassian. My team and I are working hard to improve the trial experience for Jira Software Cloud. We are interested in   talking to 20 people planning t...

83 views 1 0
Join discussion

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