JQL to exclude epics belonging to initiative

[AbrahamA]

Hi All

I am using Jira 8.5.8 and scriptrunner 6.20

I need to track a set of epics. However I would like to exclude epics belonging to couple of initiatives.

Using query below, I can get of list of epics to be excluded.
project = "Works" and issuetype= epic and ("Parent Link" in (TAN-37,TAN-67))

However, I need write a query which all other epics in the project except the ones I got above. I have tried (not in, != etc)
project = "WorkEvents" and issuetype= epic and not in ("Parent Link" in (TAN-37,TAN-67))
Nothing works

Can you please help.

Thanks

Abe

[Daniel Fietta · Accepted solution]

Hi Abe,

Not sure why you mentioned ScriptRunner, but I assume you are using the Parent Link field of the Advanced Roadmaps app.

Those JQL operators don't work with the Parent Link field. In your case, you could use "key not in childissuesOf()". E.g. project = "Works" and issuetype = epic and issuekey not in childissuesOf(TAN-37) and issuekey not in childissuesOf(TAN-39) 

Here is the documentation for that: https://confluence.atlassian.com/jiraportfolioserver/searching-for-issues-using-portfolio-details-940678957.html

Cheers,
Dan
STAGIL 

[Hana Kučerová]

Hi @AbrahamA ,

it is confusing for me, in which project are you trying to search. The first JQL contains project "Works", but second JQL contains "WorkEvents". 

"Parent Link" is Multiple Issue Picker custom field, right?

Thank you for the clarification.