JQL find all issues where parent has a specified value

[Alex Puskul]

Howdy folks
I'm wondering if its possible to create a query which would find all child issues where the parent issue has a specific value set.

For example; Find any program epics where cf[15800] = PI01 and show me any EPIC or other issues which roll up into the epic.

[Trudy Claspill · Accepted solution]

Hello @Alex Puskul 

Welcome to the community.

What version of Jira Server/Data Center are you using?

This page is the home page for Advanced Searching.

https://confluence.atlassian.com/jirasoftwareserver/advanced-searching-939938733.html

It includes links to pages on various topics including the advanced searching Functions that are available:

https://confluence.atlassian.com/jirasoftwareserver/advanced-searching-functions-reference-939938746.html

Natively the ability to find "parents" based on a filter applied to "children" or vice versa is not supported. However, if you have Advanced Roadmaps for Jira there are a few additional search functions available.

If you don't have Advanced Roadmaps, or that doesn't provide the search extension you need, then you have to explore third party apps that extend JQL search capabilities.

https://marketplace.atlassian.com/search?hosting=server&product=jira&query=jql%20exten

I personally have used the Adpatavist Scriptrunner and really liked it, but there are other options available.