JQL Help with work logs?

[Gleb Kartashov]

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:

My JQL:

project = "SD" and created >= 2020-12-01 and created <= 2020-12-22 AND timespent is EMPTY

[Joseph Chung Yin]

@Gleb Kartashov -

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

[Joseph Chung Yin]

@Gleb Kartashov - Furthermore if you have ScriptRunner for Jira installed, then you can use the issueFunction call for "workLogged" to assist your effort.

EX - project = TESTPROJECT and issueFunction in workLogged("after 2020/01/01")

Best, Joseph

[Walter Buggenhout]

Hi @Gleb Kartashov

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.