JQL Does not show resolved by specific date. But does for date range.

dave April 6, 2021

I am trying to have JQL that reflects what was "closed" on a specific date

ie: project = "Test" AND resolved = 2021-03-29

I get "No issues were found to match your search"

However, if I search for a range that includes the above date I can see there are issue(s) on that date.

project = "Test" AND resolved >= 2021-03-28 AND resolved <= 2021-03-31

resolved.png

What's the deal?

1 answer

1 accepted

1 vote
Answer accepted
Walter Buggenhout
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
April 6, 2021

Hi @dave,

I think the reason is that resolved is actually a Date/Time field. I did a small test in a local instance to notice that the following statement did not return any results, as you describe too:

Resolved = 2021-04-06 

I did locate an issue that had 2021-04-06 09:50 as resolution date. But the database is even more precise, so I needed the following statement to locate this one issue:

resolved >= "2021-04-06 09:50" AND resolved <= "2021-04-06 09:51"
dave April 7, 2021

That does work @Walter Buggenhout , thanks. But that is a pita to keep updating. 

Suggest an answer

Log in or Sign up to answer