Find issues updated from yesterday 4pm to today 4pm

N R May 24, 2017

Hello I am trying to create a JQL to retrieve all issues that were updated from yesterday 4:00 pm up to today 4:00 pm as a 24 hr report. Can someone please help me with this

1 answer

0 votes
Chander Inguva
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
May 24, 2017

Hey NR,

Try this out 

updatedDate >= startOfDay(-8h) AND updatedDate >= startOfDay(16h)   ORDER BY updatedDate ASC 

Hope this helps

Chander

N R May 25, 2017

Thank you chander.

Lets say i only want to see updates made by 3 specific people from yesterday 4 pm to today 4pm. lets call those 3 people as scott, mark and jack. is that possible?

for ex - either they added a comment or added a file or changed the status or assigned to for a JIRA issue etc. is it possible to see what updates they have made as part of the search?

Suggest an answer

Log in or Sign up to answer