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

Abhineet
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
October 29, 2023

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

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")

2 answers

1 vote
Sanjog Sigdel
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
October 30, 2023

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.

1 vote
Mohanraj Thangamuthu
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
October 29, 2023

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

 

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

 

Screenshot 2023-10-30 at 11.36.25 AM.png

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
FREE
PERMISSIONS LEVEL
Product Admin
TAGS
AUG Leaders

Atlassian Community Events