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

paul May 11, 2024

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

 

2 answers

2 accepted

4 votes
Answer accepted
John Funk
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
May 11, 2024

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.

0 votes
Answer accepted
paul May 11, 2024

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?

paul May 13, 2024

Thank you, this seems to work well.

 

Suggest an answer

Log in or Sign up to answer