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; } } }

JQL query for filtering all subtasks of specific tasks

Olga Wallace

Hi All,

EDITED: How do I modify the filter below to show only Subtasks & parent Epics of Tasks called "change management task" (tasks should not be visible, only epics & sub-tasks).

project = RRP AND issuetype= task AND text ~"change management task" ORDER BY Rank ASC

Comments

Matthew Chapman_q99b9o

Hi There, I think you might need to use AND issuetype= Sub-task to return only the sub-tasks you are looking for, cheers

Cengiz Akyildiz

Hi,

I think you need something like this,

issue in subTaskOf("project = RRP AND issuetype= task AND text ~ \"change management task\" ") ORDER BY Rank ASC

which is available with Scriptrunner!

Cheers

Olga Wallace

Sprictrunner is not an option unfortunately

Olga Wallace

it didn't work

Mani_dvkf39

Hi, Check below if that helps!

#if you multiple parent task with similar summary
project = RRP AND issuetype = Sub-Task AND text ~ \"change management task\"

or
#if you have single parent task number

project = RRP AND issuetype = Sub-Task AND "Parent Link for Task" = "issue-key" AND text ~ \"change management task\"

or
#if you have multiple parent task number
project = RRP AND issuetype = Sub-Task AND "Parent Link for Task" in (issue-key, issue-key) AND text \"change management task\"

Olga Wallace

it doesn't like the statment project = RRP AND issuetype = Sub-Task AND text ~ \"change management task\"

Screenshot 2022-12-01 014646.png

Cengiz Akyildiz

Then it is unlikely you can achieve what you trying to filter. If you can identify the the keys for those tasks then you may use something like this,

project = RRP AND parent in (<issuekey1>,<issuekey2>,...) ORDER BY Rank ASC

Radka Svobodova

Hi, it won't be working as you expect either way without some add on for extended JQL queries. In the basic jira query you can not filter subtasks of parent/s defined by another query.

Either You need some add on for it or you need to divide the query to two steps and manually change it always when you need it (not useful for dashboards with automatic updates). The first you need to find all the parent issue with the text - anotation is: text~"change management task", and it will find all the parent issues, you tak list of the found issue keys and make a second query with them in parenthesis: issuetype = Subtask AND parent in (PRP-1, PRP-2...)

Workaround could be use the automation to put labels to the subtasks and than make query based on subtasks issue type and the lable

Syed Muhammad Umair Mansoor

Hi, Try this:
project = RRP AND issuetype= task AND parent in (issue-key) AND issuetype in (epics, sub-tasks)

Olga Wallace

replaced (issue-key) with the actual issue id, no issues were found to match the search

Radka Svobodova

yes because this query makes itself never match - you want all issues that are at the same time type "task" and "epics or subtasks", so from that query delete <AND issuetype= task> and epics wont be found with this query, because it wont fit <parent in>, you need to divide search for subtasks and for epics with <OR>

(project = RRP AND parent in (issue-key) AND issuetype = sub-tasks) OR (project = RRP AND parentEpic = (issue-key))

I think because you are escaping the quotations in your JQL it is taking /"change as a term and expecting another key word after it, try:

project = RRP AND issuetype = Sub-Task AND text ~"change management task"

Haddon Fisher_x2elp7

Cengiz Akyildiz is correct as far as I know that there is no JQL functions out-of-box that let you do this kind of 'nested' or relational querying. The feature request is JRACLOUD-21936 for anyone who wants to add their howls to the void.

However if you are willing to use a custom field and Automation, you could set a flag if\when the parent has "change management task" in the title and search for sub-tasks with the flag set.

S Fong

What is the issue key and issue type for "change management task"? I am assuming that the issue type is the parent of the subtasks that you are trying to query on.

Try this:

project = PRP AND issuetype = "Sub-task" and "Parent Link" in (Issue Key)

where Issue Key is the parent issue of the "change management task"

S Fong

It works on mine when I tried to pull the sub-tasks of a specific parent link or multiple as well.

Welcome!

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