Barely different JQLs based on worklogDate returning different issues

[meliodas16]

Hello Community,

Here are two JQLs:

1. project = APC and worklogdate >= 2022-08-25 and worklogdate <= 2022-08-25
2. 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

[John Funk]

Hi @meliodas16  - Did you ever get this solved? 

[meliodas16]

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.

[Ariel Kauan]

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 :/