how to view the list of parents

[Monika Sobocka]

I want to build an advanced filter:

step 1. Find tickets that meet the filter as below

step 2.  Display parents of tasks from step 1

For Example, in Step 1 I receive 2 tasks.

First one:

Second one:

so, my advanced filter should display SYS-540 and SYS-535 tasks. How can I achieve this?

[Jack Brickey · Accepted solution]

Hi @Monika Sobocka , welcome to the community.

So you can't achieve that nativly with JQL. You would need an add-on, such as scriptrunner to achieve via a query. However, one option, although a bit ugly, would be to use automation to label the parents. Using your example, whenever a subtask was created with a summary that had "layout" then it would add a label (layout) to the subtask's parent. In this way you could query for issues where the label has "layout". Obviously, this is not very dynamic and would require a lot of manual effort on your part but if it's a occasional task, then not a big deal.

[Charlotte Santos -Appfire-]

Hi @Monika Sobocka 

I’m Charlotte, a support engineer at Appfire and I’m here to help you.

Unfortunately, using vanilla JQL, you’ll not be able to do it dynamically.

In the app where my team works, JQL Search Extensions for Jira, you can use this query to find the parents of the subtasks as you mentioned above:

issue in parentsOfSubtasksInQuery("summary ~ layout AND status = 10001")

Please contact our support if you have any other questions about this query.

We’ll be happy to help you!

Best regards,

Charlotte