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

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