Querying modifiedTimestamp in CloudKit

Question

Created Sep ’24

Replies 1

Boosts 0

Participants 2

I have a requirement to get all records changed after a certain date. I have set modifiedTimestamp as Queryable, but when I attempt to do any query at all using the following operators: > < >= <= no results are returned. I have confirmed there are records that should be returned. The only operator that works is == and !=.

I have tried the following: NSPredicate(format: "modificationDate > %@", lastFetched as NSDate) NSPredicate(format: "___modTime > %@", lastFetched as NSDate)

Boost

Answer 1

DTS Engineer OP

Apple

Oct ’24

Did you try with CloudKit Console yet?

If CloudKit Console returns the right result for the query with the same predicate, you confirm that the server side works well, and can focus on your code.

Otherwise, it may be that your CloudKit database isn't completely indexed, which can be because:

Your index was just created, and indexing takes time for a large data set.
CloudKit can't index the database for some reason.

For #2, you can try to remove and re-create the index to see if that changes anything.

Best,
——
Ziqiao Chen
 Worldwide Developer Relations.

1