How to JQL the following need? Edited

Hi Jira Family

My need is to come up with JQl so that i pull the following data.

project have subtasks. In subtask form, we have cascading custom field and in parent two of the cascading field, we have 4 options. Now i need jql so that it pulls parent tasks with subtask holding one of the options from cascading custom field.

My trys with no luck

issueFunction in hasSubtasks() AND project="ABC" and "cascading field" = "option" ORDER BY issuekey ASC

issueFunction in subtasksOf("project in ('ABC')")AND issuetype in ("Parent", "Sub-task")"  AND "cascadingfield" = "option" ORDER BY issuekey ASC 

Filter results should display parent and subtask and as I use issuekey to orderby, in default i get parent and issue id's..something like attached screenshotCapture.PNG

2 answers

1 accepted

0 votes
Accepted answer
Josh Steckler Community Champion Dec 12, 2017

Maybe this?

((project = ABC and issuetype = parent and issuefunction in hasSubtasks()) or (issueFunction in subtasksOf("project in ('ABC')")) AND "cascadingfield" = "option" ORDER BY issuekey ASC 

Thank you for sharing your knowledge. Your JQL goes 1 step ahead of what am looking for.

0 votes

I think your JQL query should look like this

(issueFunction in subtasksOf("project in ('ABC')") OR issuetype in ("Parent")) AND "cascadingfield" = "option"and project = "ABC" ORDER BY issuekey ASC

Thank you Alexey, your query works as well. 

Suggest an answer

Log in or Sign up to answer
Community showcase
Published Jan 08, 2019 in Jira

How to Jira for designers

I’m a designer on the Jira team. For a long time, I’ve fielded questions from other designers about how they should be using Jira Software with their design team. I’ve also heard feedback from other ...

1,087 views 4 9
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