Find issues updated from yesterday 4pm to today 4pm

Question

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

N R · Answer

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?

Chander Inguva · Answer

Hey NR,

Try this out

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

Hope this helps

Chander