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

[Danielle Green · Accepted solution]

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.

[Danielle Green]

jql-search-extensions-for-jira 

rich-filters-for-jira-dashboards 

scriptrunner-for-jira 

[Paul Woodington]

Thank you @Danielle Green , very helpful.

[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]

Thanks Bill.

[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.

As an example, here's how this would work in the app that my team is working on, JXL for Jira:

You can either view and edit your issues directly in JXL, export your issues in various formats, or use JXL to trigger a number of Jira operations. 

Hope this helps,

Best,

Hannes

[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

[Paul Woodington]

Hi, thanks for replying.  I tried this but it doesn't work.

[mauricio.groth]

Hi @Paul Woodington 

Thank you for replying.

Could you please share with me a screenshot showing the query running and the error happening?

Also, could you show me what issue should return?

We’re looking forward to hearing from you

Best Regards

Maurício Groth