How to capture epics that are still in progress older than a specific date?

Question

Hello,

I like to produce a report that captures epics that are still in progress older than a specific date.  I don't what to use the created , since these epics could be created a year ago.  I am looking for these epics are not closed and still in progress before April 2, 2024.  What field could I use and what would be query?

Thanks

paul_h813yj · Accepted Answer

project in (ABC) AND (team ~ Lions) AND type in (Epic, Sub-task) AND Status not in (Closed, Done) AND (updated <= "2024/4/2") ORDER BY Rank

I think this query will work, but I am not sure.  My goal is to capture epics not closed and still in progress state before 4/2/2024.  Can you help to confirm?

John Funk · Accepted Answer

Hi Paul,

Try this:

project in (ABC) AND (team ~ Lions) AND type in (Epic, Sub-task) AND statusCategory!= Done AND Status CHANGED TO “In Progress” BEFORE 2024-04-02 ORDER BY Rank

I have not tested this but hopefully it will get you close enough to tweak it.