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

Accepted Answer
0 votes
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
Alexey Matveev Community Champion Dec 12, 2017

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
Posted Sep 25, 2018 in Jira

Atlassian Research Workshop opportunity on Sep. 28th in Austin, TX

We're looking for participants for a workshop at Atlassian! We need Jira admins who have interesting custom workflows, issue views, or boards. Think you have a story to sha...

441 views 7 5
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