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

Find all issues of an epic, where the epic has a name like 'SomeString'

Paul Woodington

Hi,

I'd like to create a custom filter which will find me all the issues associated with multiple epics. Now I know I can do it like this:

project = Project-name AND parent in (ISSUE-1, ISSUE-2)

But I'd rather do it like this:

project = Project-name AND parent in ( EpicName ~ SomeString )

Is that possible?

Thanks

Accepted answers

Danielle Green_1lthiv

In a word, no. Or rather, I've not been able to find that native functionality, despite much searching, as JQL only has limited nested queries. I've used the workaround that you specify. Apps, such as Scriptrunner, can provide that extra layer of reporting. If you'd like it as a gadget on a dashboard, I'd recommend Rich Filters.

Someone may be along to tell us that it can be done, otherwise, maybe there's a feature request for JQL since it's such a popular (and obvious) requirement.

All comments

Danielle Green_1lthiv

Someone may be along to tell us that it can be done, otherwise, maybe there's a feature request for JQL since it's such a popular (and obvious) requirement.

Danielle Green_1lthiv

jql-search-extensions-for-jira

rich-filters-for-jira-dashboards

scriptrunner-for-jira

Bill Sheboy

Hi @Paul Woodington

How often do you need to do this, and how will you use the results?

When you need something like this often, consider investigating marketplace addons for JQL or reporting as Danielle suggests.

If you need this once, a work-around is to use two queries:

First search to find the epics. As the Epic Name is being deprecated, this will become easier as you can use the CONTAINS "~" operator on Summary.
Export the results of the first query, grab the keys, and make a CSV list out of them
Finally, create a second search which uses parent IN (your CSV list of keys)

Kind regards,
Bill

Paul Woodington

Thank you @Danielle Green , very helpful.

Paul Woodington

Thanks Bill.

mauricio.groth

Hi @Paul Woodington

As you're on Jira Cloud, the correct answer is to get an app that provides JQL extensions you're looking for.

With standard JQL, you can only get a list of issues and export them to Excel for further processing. This works if you want to do a one-off analysis. If your use case is more dynamic than that, look beyond standard Jira.

Standard JQL doesn't easily allow it, but you can quickly find the results using our professional indexing service JQL Search Extensions

You can use this query to find all the Stories where the amount of Acceptance bugs is more than 5.

issue in childrenOfEpicsInQuery("text ~ SomeString") and project = Project-name

Check out the documentation for more examples.
I hope this helps!
Maurício

Hannes Obweger - JXL for Jira

Just to add to Danielle's answer, another option is to go via one of the more hierarchy-focused apps on the Atlassian Marketplace. These apps usually don't rely on "native" JQL to figure out parent/child relationships, but have their own ways of doing so.