Filter query to show all epics with their summary containing text "PDP" and all their child tasks

[Munir Patel]

Would appreciate if someone can guide me to create a JQL query to display all EPICs containing text "pdp' in their Summary and also bring in all the Child Tasks for these epics

[Mikael Sandberg]

You would need an app from the Marketplace in order to do this. I know that JQL Tricks, Enhanced Search can do this because they extend default JQL. You can also have a look at JXL, that app can also get you the result you are looking for.

[Trudy Claspill]

I concur. Such a filter cannot be constructed with only native Jira filter capabilities. 

Besides the apps that @Mikael Sandberg mentioned, another one that would work is Scriptrunner Enhanced Search which provides the issuesInEpics() function

https://docs.adaptavist.com/sr4jc/latest/features/scriptrunner-enhanced-search/scriptrunner-enhanced-search-jql-functions/links-and-relationships#issuesinepics

Example:

issuetype=Epic and summary~"PDP" or issuefunction in issuesInEpics("issuetype=Epic and summary~'PDP'")