Excluding Children of an epic in a certain status (JQL)

Question

Hi

I am relatively new to Jira so struggling a bit with JQL.

I want a filter where I want to see all issues except those with a parent epic is in Status hold.

Something like..

project = XX AND status in (x, x, x, ) AND Parent epic status is not on hold.

Can I do this is standard JQL?

Thanks in advance!

Nadine Sidhpura · Answer

Thank you! I will ask and try it out...

Peter DeWitt · Answer

Nadine, not sure if you have scriptrunner but if you do, this guy will work for you.

issuefunction in issuesInEpics('project = XXX AND Issuetype = Epic AND Status != "On Hold"')