Hi, I need to find issues that have no time logged on them.
timespent is EMPTY doesn't work, this is an issue returned by query using this parameter:
project = "SD" and created >= 2020-12-01 and created <= 2020-12-22 AND timespent is EMPTY
If you were to run the same query again now, would that same issue still show in your search results?
Though it's still early in the morning and I may not be very well awake yet, I don't see anything wrong with your JQL. It should return the correct results. I think there may be an indexing issue or a delay between the moment you ran the query and the background processing of those 5 minutes that were logged in the system. If my guess is correct, then the worklog might have come in just when you ran the query and wasn't properly indexed yet.
I agreed with Walter's reply. Your JQL looks fine. Your JQL should not return the issue in your screenshot, since it has logged work. You need to work with your Jira systems admin to look into the indexing process to see if there are any issues causing the JQL oddity.
Best, Joseph Chung Yin
We often have questions from folks using Jira Service Management about the benefits to using Premium. Check out this video to learn how you can unlock even more value in our Premium plan. &nb...
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events