JQL Filter for Epic and its linked tasks

[Jeff Clay]

I'm trying to figure out the proper JQL filter syntax to accomplish this.

• Scope is multiple projects.
• Epic Name starts with "Onboarding -" or "Offboarding -"
• All tasks blocking the above filtered epics.

This filter will be used for populating a Plan.

[Jeff Clay · Accepted solution]

From the other comments, I have learned that Jira doesn't have the functionality I was looking for. The work-around I went with was adding the labels "onboarding" or "offboarding" to the respective epic's and tasks. This allowed me to filter by label in the necessary projects.

[Rahul_RVS]

Hi @Jeff Clay 

If you would be interested in a third party add-on, you can try out our app to visualize the hierarchy and track the progress at each hierarchy level.

You can use the JQL option in the app to filter out Epics with Names starings with "Onboarding -" or "Offboarding -" and view/manage all the issue linked to those Epics

Agile Tools - Epic Tree, Links Tree and Time in Status 

Key features of Links Hierarchy:

• Hierarchy upto 10 levels deep
• Progress % on "remaining estimate" or "original estimates"
• Edit Issue summary, time estimates, story points and assignee on the tree with real time updates in the progress
• Rolled up percentage completion at all levels
• Ability to add/remove the columns on the report

[Sandesh Shetty]

@Jeff Clay 

If you have script runner addon bellow JQL will work.

project in (X,Y,Z) AND issueFunction in linkedIssuesOf("'Epic Name' ~ 'Onboarding' OR 'Epic Name' ~ 'Offboarding'", "blocks")

Please refer this doc. https://scriptrunner.adaptavist.com/latest/jira/jql-functions.html#_issue_links

[Jeff Clay]

We're not currently using any 3rd party plug-ins.

[Trudy Claspill]

Do you have any third party apps on your instance that extend the JQL functionality? I think you will need some functionality that is not natively available to get this in one final filter.

Currently Jira does not natively support nested filters. It also does not support sophisticated reporting on issues based on linked issues. See https://support.atlassian.com/jira-software-cloud/docs/advanced-search-reference-jql-functions/#Advancedsearchingfunctionsreference-linkedIssueslinkedIssues--

[Trudy Claspill]

@Jeff Clay 

Noting your response on the other reply that you are not using third party apps, you have only two choices:

1. Execute multiple queries, exporting the data of one and formating it to use as input in the next

2. Use the Rest API to construct a program to get the data.

If this is something that you expect to use repeatedly, I would suggest investigating option #2 or investing in a third party app.

[Jeff Clay]

@Trudy Claspill 

Thanks for the suggestions. I was considering using labels "Onboarding" and "Offboarding" for these tasks and epics since they're all created using automation. That way I can just create a filter for those two label strings. Any idea why that wouldn't work?