Barely different JQLs based on worklogDate returning different issues

Question

Hello Community, Here are two JQLs: * project = APC and worklogdate >= 2022-08-25 and worklogdate <= 2022-08-25 * project = APC and worklogDate >= 2022-08-25 and worklogDate <= 2022-08-25 These ones are supposed to return the same set of tickets as fields in JQL are not supposed to be case sensitive right ? When executing the one above we get two different set of issues : The first JQL (with worklogdate not worklogDate) is returning issues that doesn't have worklog logged on 2022-08-25. I don't know if this may help but when checking Query Profile the two queries have different data in the Lucene tab : The first one (which is returning the wrong set of data) is showing : The second one (which returning the right set of issues) is showing : Does any one have an idea regarding this behviour ? Thanks

meliodas16 · Answer

Hello @John Funk ,

Unfotunatley no. I kept on using worklogDate as a workaround

However i didn't check with the latest versions of Jira.

Kind regards.

John Funk · Answer

Hi @meliodas16  - Did you ever get this solved?

Ariel Kauan · Answer

Hi!
In fact, consider the worklogDate. When building the query, the syntax must always be in this pattern of the next word starting with a capital letter.

I inspected the page during testing (adding a longer period), and worklogdate gave me a 429.
Maybe support can check the process logs.

Confused :/