Parse Server Cloud Code Query to Pointer

Question

this is the structure of my Database with the classes:

User -> objectId (String) username (String)

Friends -> objectId (String) toUser (Pointer <_User> ) fromUser (Pointer <_User> )

My goal is to retrieve the users with the usernames, which matches the columns toUser and fromUser with a specific Id. The Pointer of toUser and fromUser variable is the objectId of the table "User"

How my query should be?

I tried this one but it doesn`t work

Parse.Cloud.define('FriendsQuery', function(req,res) {
const friends = new Parse.Query("Friends");
friends.equalTo("toUser","fEjQgAPvDO");
const userQuery = new Parse.Query("User");    

userQuery.matchesQuery('friend', friends);
userQuery.find().then((results) => {
    res.success(results);
})
.catch(() =>  {
  response.error("user lookup failed");
});
});

I have included only the toUser column in this query

Any idea?

Thank You

Alon Raskin Alon Raskin · Accepted Answer · 2017-10-14T11:14:25

The third line in your code should look like this

friends.equalTo("toUser",{__type:"Pointer", className:"User", objectId:"fEjQgAPvDO"});

__type is always going to be Pointer
className is the name of the collection where the objectId is stored. In other words its the 'table' where the Pointer is pointing to
objectId is the ID in that 'table/collection'

Parse Server Cloud Code Query to Pointer

2 Answers