Missed Team ’24? Catch up on announcements here.

×
Create
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Products
See all
Community resources
Top groups
Explore all groups
Community resources
Learn
Community resources
Events
Community resources

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

Navneet Rayat
Navneet Rayat
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!
Get involved
February 15, 2018

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

Answer
Watch
Like Be the first to like this
6256 views

2 answers

2 votes
Ivan Tovbin
Ivan Tovbin
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.
Get recognized
February 15, 2018

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. 

Reply
0 votes
Sean Young
Sean Young December 14, 2020

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.

 

search.png

Reply

Suggest an answer

Log in or Sign up to answer
Jira
Jira
TAGS
AUG Leaders

Atlassian Community Events

    See all events