How can I query Epics by issue title contained?

Question

Hallo everyone!

I have to query all the Epics in a project containing issues (tasks) named "Installation" and NOT containing issues named "Rechnungsstellung".

Is there a way to do this?

I tried with this search:

type = Epic AND project = XXX AND text~ "installation" AND text!~ "Rechnungsstellung"

and this

type = Epic AND project = XXX AND issue~ "installation" AND issue!~ "Rechnungsstellung"

but it didn´t work.

Thank you in advance.

karel_mellen · Accepted Answer

Far from perfect, but this might help you?

https://community.atlassian.com/t5/Jira-Core-Server-questions/Search-for-issues-that-do-not-contain-text/qaq-p/455633

Hannes Obweger - JXL for Jira · Accepted Answer

Hi @Lorenzo

welcome to the community!

If I understand you correctly, you have two "problems" - first, grab issues that contain one word but not the other, and second, to grab the epics that contain these very issues.

For the former, @karel_mellen's answer might help.

For the latter: That's not really possible in "native" JQL, unfortunately. You'll need to,

* either try one of the various JQL extensions that are available on the Marketplace. I'm not really an expert in these, but JQL Search Extensions has a "EpicsOfChildrenInQuery" function that sounds promising; 
* or try one of the various hierarchy-focused apps from the Marketplace. These apps don't rely on JQL to establish parent-child relationships, but have their own ways of doing so.

Hope this helps,

Best,

Hannes