Parse.com query with relation

Question

Im try to run this query in parse.com, But Everyone not working.

I have 2 tables, One for Promote and second for Archive.

So, I need to fetch all rows in Promote table where is not in archive table.

Like this SELECT * FROM promote WHERE id NOT IN (SELECT promoteID FROM archive WHERE user=userID).

promoteID in archive is Pointer to objectId in Promote Table.

any help Please?

TonyMkenu · Accepted Answer · 2014-11-10 14:20:28Z

1

Try something like this....

PFQuery *innerQuery = [PFQuery queryWithClassName:@"Archive"];
[innerQuery whereKey:@"user" equalTo:[PFUser currentUser]];
[innerQuery orderByDescending:@"createdAt"];

PFQuery *query = [PFQuery queryWithClassName:@"Promote"];
[query whereKey:@"id" doesNotMatchQuery:innerQuery];
[query findObjectsInBackgroundWithBlock:^(NSArray *records, NSError *error) {
    if (error) return;
    for (PFObject *record in records) {
        // .....

       }
}];

answered Nov 10, 2014 at 14:20

TonyMkenu

7,6523 gold badges31 silver badges53 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Parse.com query with relation

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related