CQL search query is not returning the proper result for between the Last modified date.

sase apiqa June 4, 2023

Hi Team ,

 

We are using the CQL to get the file modified details , it not returning immediate results but same query return the result after 24 hours . 

Some time not given proper results as well. 

CQL: lastmodified >= "2023/05/24+15:54" and lastmodified < "2023/05/29+07:12"

 

Please help us to resolve the issue, let us know any required changes we have to do. 

 

CQL: lastmodified >= "2023/05/24+15:54"

Results :Correct results.

Last modified 1.png

lastmodified >= "2023/05/24+15:54" and lastmodified < "2023/05/29+07:12"

Result: Wrong Results

Last modified 2.png

1 answer

0 votes
Aron Gombas _Midori_
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
June 5, 2023

Are you sure that those '+' characters between the date and the time are necessary?

The official guide shows this example:

lastmodified >= 2014-09-01 and lastmodified < "2014-09-03 09:00"

 There is no '+' there...

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
TAGS
AUG Leaders

Atlassian Community Events