JQL to find epics with stories in To-Do or Cancelled

[Kalyan Sattaluri]

Hi,

Need help with creating this query.

Our Epics have statuses:

• Discovery
• Plan/Refine
• Started
• Pending Acceptance
• Accepted

Our Stories have statuses:

• To-Do
• In Progress
• Done
• Cancelled

What I need to find is, Epics which has status as Started but stories are either in To-Do or Cancelled.

We have scriptrunner on our instance so any help creating this JQL would be great!

[Kalyan Sattaluri]

I was able to get the query using @JamieA answer from way back when from this thread : LINK

Project = XYZ AND STATUS = STARTED AND issueFunction in linkedIssuesOf('status in ("To Do", Cancelled)', "has epic") AND not issueFunction in linkedIssuesOf('status NOT in ("To Do", Cancelled)', "has epic") 

query runs slow, so any improvements will be great!