nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to JQL the following need?

KRC

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 screenshot

Accepted answers

Josh Steckler

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

All comments

Alexey Matveev

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

Josh Steckler

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

KRC

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

KRC

Thank you Alexey, your query works as well.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

jql