PFQuery where array of pointers contains a certain PFObject

Question

Objects in my class Deal have an attribute relatedContacts which is an array of pointers to Contact objects. I'm running the following query to determine whether the current Contact object is the target of a pointer in any Deal, prior to deleting the Contact.

let relatedContactObjects:NSArray = [self.contactObject] as NSArray

let relatedContactQuery:PFQuery = PFQuery(className: "Deal")
    relatedContactQuery.fromLocalDatastore()
    relatedContactQuery.fromPinWithName("Deals")
    relatedContactQuery.whereKey("user", equalTo: PFUser.currentUser()!)
    relatedContactQuery.whereKey("relatedContacts", containsAllObjectsInArray: relatedContactObjects as [AnyObject])

However this returns Parse Error 102: "Value type not supported for $all queries."

The Parse documentation says that containsAllObjectsInArray takes an NSArray, but Xcode shows a warning that NSArray is not implicity convertible to [AnyObject].

Any ideas how I can make this query work?

Edit: I looked at the contents of relatedContacts and it seems that each instance contains an array of dictionaries, example: [{"__type":"Pointer","className":"Contact","objectId":"BoLym053hX"},{"__type":"Pointer","className":"Contact","objectId":"AgpnxAFUBn"},{"__type":"Pointer","className":"Contact","objectId":"ob20tThdfp"}]

As suggested, I've also looked at the containedIn query constraint, but that is used to identify objects that are contained in a given array. I am trying to identify arrays that contain a given object.

At the top you have relatedContactObjects as an NSArray, why are you casting it to [AnyObject] ? — shim
– shim, Commented Aug 25, 2015 at 15:19
Xcode requires that it be cast to [AnyObject], but actually I don't think that is the problem. Please see my updated question. — blwinters
– blwinters, Commented Aug 25, 2015 at 15:28
Don't think that method supports that kind of thing. You might want to try containedIn This question may help. — shim
– shim, Commented Aug 25, 2015 at 15:29
Thanks, but that constraint is used to identify objects that are contained in a given array. I am trying to identify arrays that contain a given object. — blwinters
– blwinters, Commented Aug 25, 2015 at 15:46

danh · Accepted Answer · 2015-08-25 17:01:40Z

4

Parse.com overloads equalTo: by allowing it to mean either: (a) a singular property equals the operand, or (b) an array property contains the operand. So you're objective is easily stated as follows:

relatedContactQuery.fromPinWithName("Deals")
relatedContactQuery.whereKey("user", equalTo: PFUser.currentUser()!)
relatedContactQuery.whereKey("relatedContacts", equalTo:self.contactObject)

answered Aug 25, 2015 at 17:01

danh

62.7k10 gold badges100 silver badges139 bronze badges

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

3 Comments

blwinters Over a year ago

Thanks for pointing that out. I thought equalTo was more literal. And just to complete your answer, here is the countObjects query I used:

relatedContactQuery.countObjectsInBackgroundWithBlock{(count, error) -> Void in             if (error == nil) {                 self.dealsPointingToContactCount = Int(count)                              }

danh Over a year ago

Glad it helped. Fyi: Parse.com disuades count queries. Depending on the count, a resource saving alternative might be a cloud function that does a find() and then answers the length of the found collection.

blwinters Over a year ago

Good to know. I'm running the query in the local datastore and the expected count is less than 100, so this should be okay for my situation.

blwinters · Accepted Answer · 2015-08-25 17:25:45Z

0

Prior to the accepted answer, I also tried using loops to go through the arrays and identify whether they contained the current object, then incremented a count.

var dealsPointingToContactCount:Int = 0
func countDealsRelatedToContact() {
    let dealsWithRelatedContactQuery:PFQuery = PFQuery(className: "Deal")
    dealsWithRelatedContactQuery.fromLocalDatastore()
    dealsWithRelatedContactQuery.fromPinWithName("Deals")
    dealsWithRelatedContactQuery.whereKey("user", equalTo:PFUser.currentUser()!)
    dealsWithRelatedContactQuery.whereKeyExists("relatedContacts")
    dealsWithRelatedContactQuery.findObjectsInBackgroundWithBlock{(objects, error) -> Void in

        if (error == nil) {

            var dealsWithPointersToContacts:NSArray = objects! as NSArray

            for deal in dealsWithPointersToContacts {

                var dealContactsArray:NSArray = deal["relatedContacts"] as! [PFObject]

                for contact in dealContactsArray {
                    if contact as! PFObject == self.object {
                        self.dealsPointingToContactCount++
                        println("Deals pointing to current contact: \(self.dealsPointingToContactCount)")
                    }
                }
            }  
        } 
    }
}

edited Aug 25, 2015 at 17:25

answered Aug 25, 2015 at 16:34

blwinters

2,20024 silver badges46 bronze badges

3 Comments

danh Over a year ago

I think you can do it the way you were first attempting. This way is okay, but consider that it will retrieve (using network resource and client memory) potentially many more objects than are needed. There's also the matter of expending compute effort on the local test. To get what you want via query, please clarify: objects where EVERY related contacts is in relatedContactObjects. Also, please indicate the type of the relatedContacts column.... an array of what?

blwinters Over a year ago

The relatedContacts column is an array of pointers to Contact objects. For the query, relatedContactObjects is an array with only one object because containsAllObjectsInArray needs an NSArray. I really just want a count of the Deal objects where relatedContacts contains self.contactObject.

danh Over a year ago

That makes your goal very easy to achieve.

Collectives™ on Stack Overflow

PFQuery where array of pointers contains a certain PFObject

2 Answers 2

3 Comments

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related