Parse object containing array elements

Question

I have a Parse object called Recipes and a column called ingredients, which is an array. I want to query my object list and retrieve a recipe based on some ingredients that I select.

If I use the whereKey:containsAllObjectsInArray: message on the query object, I will get recipes with more ingredients. Also, whereKey:containedIn: does not solve my problem. The retrieved objects should have an array of ingredients containing all my selected ingredients or only some of them. It should never have more ingredients than those I've selected.

Any ideas?

That does not really make sense from a logical point of view... why would you have to specify ALL ingredients to get the recipe? — luk2302
– luk2302, Commented Jun 28, 2015 at 10:51
I want to retrieve the recipes that I can make using some ingredients (available in my house at that moment). I don't want to retrieve any recipes that requires more ingredients than I currently have available. — Rares
– Rares, Commented Jun 28, 2015 at 10:53
Can't you just fetch all the results for that ingredient set and then use some logic to filter out the ones with extra ingredients in your app? — Kex
– Kex, Commented Jun 28, 2015 at 13:25

Kex · Accepted Answer · 2015-06-28 13:33:29Z

1

You could add an extra column to your recipe table "array count" for the number of ingredients in the recipe. Then do a multiple query:

[query whereKey:ingredients containsAllObjectsInArray:ingredientsArray];
[query whereKey: arrayCount equalTo:[ingredientsArray count]];

That way you are only returning things with the same number of ingredients and all the ones you listed.

answered Jun 28, 2015 at 13:33

Kex

8,68713 gold badges67 silver badges146 bronze badges

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

1 Comment

Kex Over a year ago

Great, yeah parse has some weird limitations. Usually means you have to find a way around it changing your data model up a bit. glad I could help!

ozd · Accepted Answer · 2015-06-28 12:09:04Z

1

You can maybe do - whereKey:notContainedIn: for all the rest of the ingredients (the ingredients this user doesn't have). and than the user will get only ingredients he has.

answered Jun 28, 2015 at 12:09

ozd

1,30414 silver badges38 bronze badges

1 Comment

Rares Over a year ago

That would be a valid workaround but I wouldn't want to send over the network all the ingredients (since there are a lot of them and I wouldn't want my app to use internet data in vain).

Collectives™ on Stack Overflow

Parse object containing array elements

2 Answers 2

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related