Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

How to search by resolved date?

t m April 5, 2022

How can I correctly search for issues that were resolved within a given year?

I have tried several variations of the following (part of query, tried with `resolutiondate` also with no change in results):

resolved >= 2021-01-01 AND resolved <= 2021-12-31

This shows some issues that were resolved during that time, but not all.

An example to demonstrate this with an issue that closed in 2021:

  • A query of just `id = {Specific id of issue}` shows the issue in question
  • A query of `id = {Specific id of issue} AND resolved >= 2018-01-01` shows no issues (again, tried also with resolutiondate, but with no change in result).

Checking the history for the issue shows that it very definitely did close in 2021, which as we all know is >= 2018-01-01. 

scrn.png

Server v8.20.6#820006

1 answer

0 votes
t m April 5, 2022

Seems like some of our issues, although they are "Done" and resolution is set at "Resolved", somehow the resolved column is empty... I have no idea why this is nor how to set it. 

Suggest an answer

Log in or Sign up to answer