JQL needed to pull all issues changing status within a date range.

Question

Someone on my team is looking to create a JQL where:
•Date range can be defined ( July 1 - XX) 
•Issues that fall under EPICS only 
•Where Issues move from OPEN to any other Status within said date range.

She is currently only selecting from certain projects which is defined by:  Project in (  ) , statement.

Any help will be appreciated.

DeAnna Law · Answer

Thank you @Shikha Verma we did a manual compare and it looks like maybe we need a slight tweak to the JQL.   Looks like maybe it is only pulling when the status is OPEN to another STATUS.  However we are looking at tickets that move from any open status to another STATUS.  So if a ticket is IN PROGRESS and moves or , IN TESTING and moves etc.

Shikha Verma_xy1o3z · Answer

Hi @DeAnna Law, You can try this: Project in (ProjectA, ProjectB) AND "Epic Link" is not EMPTY AND status WAS "Open" DURING ("2023-07-01", "2023-XX-XX") AND updated >= "2023-07-01" AND updated <= "2023-XX-XX" OR project in (Project1, Project2, ...) AND "Epic Link" is not EMPTY AND status changed FROM "Open" AND updated >= "2024-07-01" AND updated <= "2024-XX-XX"