How can I write a JQL query for Epics with multiple parameters?

[Holly Schomann]

Can I write a JQL query to filter for all Epics that have a status of 'To Do', AND 'In Progress' AND any epic whose status was marked as 'Done' in the past 30 days?

Is it possible to retrieve both of these groups in one JQL query?

Appreciate your help!

[Sreenivasaraju P · Accepted solution]

Hi @Holly Schomann , 

Yes. you can do this with JQL.

You can try with below query.

issuetype = epic and (status in ("To Do", "In Progress") or (status = Done and status changed AFTER -30d))

[Holly Schomann]

Thank you so much for your help!  This almost works. For some reason I am now getting non epic tickets if they have changed in the past month?

[Sreenivasaraju P]

try below query. 

(issuetype = epic and status in ("To Do", "In Progress")) or (issuetype = epic and status = Done and status changed AFTER -30d)

[Holly Schomann]

This worked!!! You are a genius!!  Thank you thank you!!

Holly