Forums

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

Should I get results when using the = operator for resolved or resolutiondate

Tom Brown
Contributor
September 6, 2023

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

1 answer

1 accepted

0 votes
Answer accepted
Kseniia Trushnikova
Community Champion
September 6, 2023

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.

Tom Brown
Contributor
September 11, 2023

Thanks for the explanation and link, not how I would expect the operator to work for date queries but explains what is going on.

Suggest an answer

Log in or Sign up to answer
TAGS
atlassian, likes for trees, atlassian community, social impact, tree planting campaign, community kudos, atlassian giving, environmental impact, sustainability, likes for good, atlassian social responsibility, community challenge

Make every click count—help us plant 50,000 trees! 🌳

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
AUG Leaders

Atlassian Community Events