Parse.com Query containedIn Array of Pointers

Question

Original Question

I'm trying to query all instances where the ID inside of allFriends matches the ID of Creator. allFriends is an array of IDs from an earlier query. What is the proper syntax for containedIn with an array of pointers.

allFriends:

["1EGomEr0Tk", "iMJbVrPfGG", "DVOwabZkaQ", "zhvd8mAdhl"]

Code:

query.containedIn("Creator", {
                __type: "Pointer",
                className: "User",
                objectId: allFriends
            })

Error:

code: 102
error: "$in requires an array"

Update #1

I've found that I need to convert the allFriends array of IDs into a pointer map. However _.map is being computed as undefined.

Code:

var pointers = _.map(allFriends, function(item_id) {
            var pointer = new Parse.Object("allFriends");
            pointer.id = item_id;
            return pointer;
            });
            query.containedIn("Creator", pointers);

Error:

Uncaught ReferenceError: map is not defined

Timothy Walters · Accepted Answer · 2015-01-15 23:00:17Z

11

If your "Creator" column is of type Pointer<_User> and your allFriends array is an array of IDs for Users, then this is what you need to do:

Create an array of Pointer<_User> objects from allFriends:

var pointers = _.map(allFriends, function(friendId) {
  var pointer = new Parse.User();
  pointer.id = friendId;
  return pointer;
});

Once you have an array of Pointer<_User> you can then compare your column:

query.containedIn('Creator', pointers);

You were very close, it was just a matter of creating the right kind of pointers.

answered Jan 15, 2015 at 23:00

Timothy Walters

16.9k2 gold badges44 silver badges49 bronze badges

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

Comments

danh · Accepted Answer · 2015-01-15 20:44:57Z

Parse lets you define a pointer column or an array column. Arrays are an ordered collection of scalar types (numbers, strings, etc) or they can be an array of pointers.

Pointers

When getting and setting a pointer, the operand is a PFObject. In other words, for the setter:

myObject.set("somePointerCol", someOtherObject);

where someOtherObject is a PFObject, possibly an empty one, with only an ID defined (as you indicated correctly in your edit). For the getter:

myQuery.first().then(function(myObject) {
    var someOtherObject = myObject.get("somePointerCol");
});

someOtherObject will be an empty PFObject with just its objectId set. If you want the referred-to object fetched as well, then qualify your query like this:

myQuery.include("somePointerCol");
// someOtherPointerCol on the retrieved object will contain a complete, fetched object

Arrays and Arrays of Pointers

PFObject provides a couple methods for arrays, you can add to an array with add and addUnique, and remove from it with remove. The elegant part is that these methods can be just as readily applied when the array is an array of pointers.

myObject.addUnique("arrayOfPointersCol", someOtherObject);
// or...
myObject.remove("arrayOfPointersCol", someOtherObject);

Finally, PFQuery deals with arrays fairly transparently. To find any myObject who's arrayOfPointersCol contains a PFObject, use equalTo, as if its just a single value.

myQuery.equalTo("arrayOfPointersCol", someOtherObject);

// if you have only an id, say someId, then
var SomeOtherClass = Parse.Object.extend("SomeOtherClass");
var someOtherObject = new SomeOtherClass();
someOtherObject.id = someId;

myQuery.equalTo("arrayOfPointersCol", someOtherObject);

Similarly to non-array pointers, you can eagerly fetch all of the elements in that array:

myQuery.include("arrayOfPointersCol");  // but be careful, keep array lengths short

Underscore

Last, and unrelated to the array or pointer ideas, you certainly can map an array of object ids, transforming them into an array of pointer objects. The code you posted looks fine, but it depends on the underscore library -- which is a very useful library that provides the _.map function among many others.

Jeremy Piednoel · Accepted Answer · 2018-05-14 15:33:33Z

1

It might be a little late but you can also use the method createWithoutData to build objects from IDs

Documentation

answered May 14, 2018 at 15:33

Jeremy Piednoel

4062 gold badges5 silver badges12 bronze badges

Comments

Alauddin Afif Cassandra · Accepted Answer · 2019-08-07 15:29:54Z

1

If you want to have multiple-pointer column, just create array column and fill it with _User objects. Result will look like this and it will really be array of pointers:

[{"__type":"Pointer","className":"_User","objectId":"kIg9Kzzls9"},
{"__type":"Pointer","className":"_User","objectId":"TGCBZm52zW"},
{"__type":"Pointer","className":"_User","objectId":"YfGT9GvJs6"}]

Using include to get full objects in query also works, it is an array of pointers.

answered Aug 7, 2019 at 15:29

Alauddin Afif Cassandra

5867 silver badges12 bronze badges

4 Comments

Itzdsp Over a year ago

Can you explain this please? include will fetch all the data from _user class as well?

Alauddin Afif Cassandra Over a year ago

for example, the data above is the data in the users column, so you can include the users column.

Itzdsp Over a year ago

But the array of pointers not retrieving the pointed object from different collection. I dont think its possible.

Alauddin Afif Cassandra Over a year ago

basically the code that I described above is "Pointer of array", and I still use it today. Try playing with the code above first

Collectives™ on Stack Overflow

Parse.com Query containedIn Array of Pointers

Original Question

Update #1

4 Answers 4

Comments

Comments

Comments

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

Original Question

Update #1

4 Answers 4

Comments

Comments

Comments

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related