CloudKit: Order query results by creation date

Question

When loading items from CloudKit I would like to order the results by creation date. I believe now it's sorting by the first property of the record.

func loadItems() {
    let predicate = NSPredicate(value: true)
    let query = CKQuery(recordType: "Items", predicate: predicate)
    db.performQuery(query, inZoneWithID: nil) { (results, error) -> Void in
        if error != nil {
            println(error.localizedDescription)
        }

        dispatch_async(dispatch_get_main_queue()) { () -> Void in
            items = results as [CKRecord]
            self.tableView.reloadData()
            println("items: \(items)")
        }
    }
}

I assume I need to use NSSortDescriptor, but I'm not sure how specifically. — colindunn, Feb 01 '15 at 21:02
Is this close? `query.sortDescriptors = NSSortDescriptor(key: "creationDate", ascending: true)` — colindunn, Feb 01 '15 at 21:56

colindunn · Accepted Answer · 2015-02-02T04:51:58.277

24

This is what I was looking for:

query.sortDescriptors = [NSSortDescriptor(key: "creationDate", ascending: false)]

edited Feb 02 '15 at 04:51

answered Feb 01 '15 at 22:14

colindunn

3,139
10
48
72

doesn't this sort in reverse order? I think the answer by @vomako below is better. – PKCLsoft Dec 15 '16 at 21:57

score 19 · Answer 2 · answered Jul 28 '15 at 10:12

Here is an Objective-C solution. It works similarly in Swift.

NSPredicate *predicate = [NSPredicate predicateWithFormat:@"TRUEPREDICATE"];
CKDatabase *privateDatabase = [self.myContainer privateCloudDatabase];
CKQuery *query = [[CKQuery alloc] initWithRecordType:@"command" predicate:predicate];
query.sortDescriptors = [NSArray arrayWithObject:[[NSSortDescriptor alloc]initWithKey:@"creationDate" ascending:true]];

With this, you may get the following error message:

CKError 0x12e874f10: "Invalid Arguments" (12/2016); server message = "Field '___createTime' is not marked sortable"; uuid = 468AC2A4-24D6-4A56-81BB-6A2A8027DC15; container ID = "iCloud.com.xxx"

So, just make it sortable in dashboard:

This should be the accepted answer, the second part of this answer is critical. — Li Fumin, Jul 03 '16 at 06:10

score 0 · Answer 3 · edited Jun 20 '20 at 09:12

0

Swift - 3.0

let recordInsertDate = records["creationDate"]!
print("recordInsertDate : \(recordInsertDate)")
let query = CKQuery(recordType: "className", predicate: NSPredicate(format: "creationDate >= %@ " , recordInsertDate as! CVarArg))

edited Jun 20 '20 at 09:12

Community

1
1

answered Apr 28 '17 at 07:56

Vishal Vaghasiya

4,618
3
29
40

Christian · Answer 4 · 2015-02-01T21:23:34.313

-1

You can use NSPredicate. You were right.

let startDate = NSDate(timeInterval: -60.0 * 120, sinceDate: NSDate())
let predicate = NSPredicate(format: "creationDate > %@", startDate)

But you have to enable the creationDate-field in the CloudKit for querying so that you can use them in a query.

edited Feb 01 '15 at 21:23

answered Feb 01 '15 at 21:11

Christian

22,585
9
80
106

Hm, I must be doing something wrong. It's still ordering by another property. I enabled both query and sort for the 'Date Created' Metadata indexes. – colindunn Feb 01 '15 at 21:17
Yeah, first two lines look like this: `let startDate = NSDate(timeInterval: -60.0 * 120, sinceDate: NSDate()) let predicate = NSPredicate(format: "creationDate > %@", startDate)` – colindunn Feb 01 '15 at 21:19
(I assume `date` was meant to be `startDate` in your code above) – colindunn Feb 01 '15 at 21:19

CloudKit: Order query results by creation date

4 Answers4

Swift - 3.0

Linked