I'm looking for issues that transitioned to in-progress any from any status in the last 24 hours.

Question

I have tried various JQL queries and got the results close to my expectations but somewhere the results were lacking the accuracy.

project = "1851 Delivery Team" AND status was "To Do" after -24h AND status in("IN PROGRESS")

project= "1851 Delivery Team" and status was "To Do" after -24h AND status in ("IN PROGRESS", "DONE ✔️" , "IN QA", "In Review", "IN EDITING")

Sanjog Sigdel · Answer

Hello @Abhineet Welcome to the community.

You can use the query updated >= -24h and status changed To "In Progress" provided by @Mohanraj Thangamuthu to get the tickets whose status changed to In Progress in last 24 hours. You can use 24h or 1d as your need in the filter query.

Mohanraj Thangamuthu · Answer

Hello, Good day. Please try the following JQL query.

updated >= -1d and status changed To "In Progress"