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

[Nadine Sidhpura]

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!

[Peter DeWitt]

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"')

[Nadine Sidhpura]

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