JQL query return Incorrect data

[Tehmina Aslam]

Hi,

I want to get the issues updated or created yesterday in Jira; today is January 16. I have added a query. 

project = "Jeeny Reboot" AND (created < endOfDay(-1) OR updated < endOfDay(-1))

 But the query returns me the issue created or updated by today or even created or updated by the 12th of January. Why is this happening? 

Thanks in advance,

[Alex Koxaras _Relational_ · Accepted solution]

Hi @Tehmina Aslam 

Please try something along the following lines:

project = "Jeeny Reboot" AND ((created >= startOfDay(-1) AND created <= endOfDay(-1)) OR (updated >= startOfDay(-1) AND updated <= endOfDay(-1)))

[Walter Buggenhout · Accepted solution]

Hi @Tehmina Aslam,

You'll need to add the start of the day as well in order to restrict your search to just yesterday. Try the following instead:

project = "Jeeny Reboot" AND
((created >= startOfDay(-1) AND created <= endOfDay(-1)) OR
(updated >= startOfDay(-1) AND updated <= endOfDay(-1)))

 Hope this helps!

[Tehmina Aslam]

Superb @Walter Buggenhout let me try that.

[Sushant Verma]

Hi @Tehmina Aslam 

Please try below JQL:

project = "Jeeny Reboot" AND ((created >= startOfDay(-1) AND created <= endOfDay(-1)) OR (updated >= startOfDay(-1) AND updated <= endOfDay(-1)))

Regards,
Sushant Verma

[Tehmina Aslam]

Thanks, @Sushant Verma. Works!