Hi,
It has just been brought to my attention that JQL such as resolved <= 2023-09-06 do not return any issues that have been resolved on 2023-09-06 (there have been), only those issues resolved prior to 2023-09-06.
Similarly if I try resolved = 2023-09-06 (or for any other date) then I get no results even though I can see that issues have been resolved on the dates specified.
However if I use resolved >= 2023-09-05 then this includes all issues resolved on 2023-09-05 (as expected) as well as those greater than that date.
Does anyone else experience this problem or can explain the logic for why <= or = operators do not work for resolved or resolutiondate.
I have tried similar searched using due and duedate and these all work as I would expect.
Thanks,
Tom
Hi @Tom Brown,
Here's the thing. Dates in JQL are transformed in date time values. The JQL resolved <= 2023-09-06 is the same as resolved <= "2023-09-06 00:00".
There's a known bug created about such JQL behavior: https://jira.atlassian.com/browse/JRASERVER-45226 It's relevant for all date fields, not only resolution dates.
Thanks for the explanation and link, not how I would expect the operator to work for date queries but explains what is going on.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Want to make your everyday Community actions directly contribute to reforestation? The Atlassian Community can achieve this goal by liking a post, attending an ACE, sending your peers kudos, and so much more!
Help us plant more trees
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.