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
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.