Parse Cloud Code relational query syntax

Question

I have a cloud function on Parse. When it's called it retrieves a PFObject then adds a relation between that object and the user. This part works fine (Seen towards the end of the function). I'm having trouble getting the query that selects the PFObject to ignore those that the user is already related to

Here is my code:

Parse.Cloud.define("NextMedia", function (request, response) {

    var LikeRequest = Parse.Object.extend("LikeRequest");
    var query = new Parse.Query(LikeRequest);

    query.equalTo("completed", false);
    console.log("user: " + Parse.User.current().id);

    query.notEqualTo("user", Parse.User.current());

    // Also only fetch if never been sent before 
    // HERE SHOULD USE THE BELOW RELATIONSHIP
    var innerQuery = new Parse.Query(Parse.User);
    innerQuery.exists(Parse.User);
    query.matchesQuery("sentTo", innerQuery);

    query.ascending("createdAt");

    query.first({

        success: function (object) {
            // Successfully retrieved the object.
            console.log("Got 1 object: " + object.get('mediaId'));

            // Record that the user has been sent it
            var user = Parse.User.current();
            var relation = object.relation("sentTo"); // RELATION ADDED HERE

            relation.add(user);
            object.save();

            response.success(object);
        },
        error: function (error) {
            console.log("Error: " + error.code + " " + error.message);

            response.error("Error getting next mediaId");
        }
    });
});

I'm sure i'm just not understanding how the relation query syntax works.

On your LikeRequest class do you have a user column? I'm not understanding query.notEqualTo("user", Parse.User.current()); — bmurmistro
– bmurmistro, Commented Apr 11, 2014 at 14:59
In the bottom section where it adds the Relation, that's adds a many to many user column. — Darren
– Darren, Commented Apr 11, 2014 at 18:03
Sorry for the delayed response. Have you tried something like this: var innerQuery = LikeRequest.relation("sendTo").query(); innerQuery.exists(Parse.User); — bmurmistro
– bmurmistro, Commented Apr 14, 2014 at 14:18
I'm away for a few days now, so will try when I get back. Thanks — Darren
– Darren, Commented Apr 15, 2014 at 11:22
Only now realized this is very old question. Did you ever come to a solution? — Tom Erik Støwer
– Tom Erik Støwer, Commented Sep 20, 2014 at 20:06

Muath · Accepted Answer · 2015-03-28 07:54:57Z

2

This stretch:

// Also only fetch if never been sent before 
// HERE SHOULD USE THE BELOW RELATIONSHIP
var innerQuery = new Parse.Query(Parse.User);
innerQuery.exists(Parse.User);
query.matchesQuery("sentTo", innerQuery);

Could be changed to:

// Also only fetch if never been sent before 
query.notContainedIn("sentTo",[Parse.User.current()])

That works.Parse Query

edited Mar 28, 2015 at 7:54

Muath

4,43712 gold badges44 silver badges70 bronze badges

answered Feb 10, 2015 at 11:39

Oscar Eduardo

3861 silver badge8 bronze badges

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

Comments

Kerem · Accepted Answer · 2015-02-08 18:59:18Z

1

what about Query Constraints?

If you want to retrieve objects that do not match any of several values you can use notContainedIn

  // Finds objects from anyone who is neither Jonathan, Dario, nor Shawn
query.notContainedIn("playerName",
                     ["Jonathan Walsh", "Dario Wunsch", "Shawn Simon"]);

answered Feb 8, 2015 at 18:59

Kerem

9938 silver badges19 bronze badges

Comments

Rog · Accepted Answer · 2015-02-09 18:10:06Z

1

I think Kerem has it partially correct but notContained in is not dynamic enough for your case.

You need to construct the query from the relation and then use doesNotMatchKeyInQuery to exclude those objects from your outer query.

answered Feb 9, 2015 at 18:10

Rog

17.1k9 gold badges52 silver badges73 bronze badges

Collectives™ on Stack Overflow

Parse Cloud Code relational query syntax

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related