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 vote
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 vote
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
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Published Monday in Jira Software

How large do you think Jira Software can grow?

Hi Atlassian Community! My name is Shana, and I’m on the Jira Software team. One of the many reasons this Community exists is to connect you to others on similar product journeys or with comparabl...

620 views 6 12
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