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

4 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


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

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

Also interested in cloud instance

Also interested (cloud instance)

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

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)

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted in Jira

Demo Den Ep. 7: New Jira Cloud Reports

Learn how to use two new reports for next-gen projects in Jira Cloud:  Cumulative flow diagram and Sprint burndown chart. Ivan Teong, Product Manager, Jira Software, demos the Cumulative ...

308 views 1 3
Join discussion

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