How to use endOfDay feature to get a list of all closed bugs since yesterday

Question

I am trying to use this query, to filter all the bugs that were closed / resolved since yesterday, how can i do it.

project = TEST AND issuetype != Story AND (status in (Closed, Resolved) and updated = endOfDay(1))  ORDER BY  updated DESC, reporter ASC, key DESC

Sean Young_st31ot · Answer

Thank you for this!  My field was in the next gen project so I clicked the admin cog > issues > Custom fields > click the 3 dots > Edit details > then changed the search template.

Ivan Tovbin · Answer

You shouldn't really use the '=' operator with startOf/endOf functions because

resolved = startOfDay()

will only return issues that have been resolved EXACTLY at 00:00 of the current day.

That said if you want to get all issues resolved since yesterday you need to use

resolved >= startOfDay(-1)

which will return all issues resolved from the beginning of yesterday.