Implementing OR Condition using Parse Android SDK?

Question

I am new to Parse and i am working on a Project that uses Android PARSE Sdk so i was wondering on how can i make a where query with or condition using the android sdk.

I want to make a query like this [Psuedo code]

Select * from employ where employId is ("1","2","3")

I found this on parse documentation, i don't know if it helps or not.

Edit:

This is what i found on PARSE but its not working

String[] id= {"1","2","3"};
query.whereContainedIn("employId ", Arrays.asList(id));

It returns me an empty list but if i query them one by one i get result... Can anyone tell me whats wrong ?

Ramesh_D · Answer 1 · 2014-07-04T06:57:31.997

3

You can use whereContainedIn to select specific rows. See this post you can get more ideas. https://www.parse.com/questions/different-arrays-and-wherecontainedin-for-android.

List<String> employId = new ArrayList<String>();
employId.add("1"); employId.add("2"); employId.add("2");
query.whereContainedIn("employId", employId);

If you are still not clear. check this https://www.parse.com/docs/android_guide#queries

edited Jul 04 '14 at 06:57

answered Jul 04 '14 at 06:31

Ramesh_D

689
1
7
25

Its not working. Can you write the exact query or code ? – Sheraz Ahmad Khilji Jul 04 '14 at 06:45
It gives error it doesn't even compile. it says "The method whereContainedIn(String, Collection extends Object>) in the type ParseQuery is not applicable for the arguments (String, String[])" – Sheraz Ahmad Khilji Jul 04 '14 at 06:52
1

bro i am doing this but its returning no records even though there are records. Before i was querying using separate values in the list and it was returning records but in this way its not returning any records – Sheraz Ahmad Khilji Jul 04 '14 at 07:11
Try with integer instead of string for employ id. – Ramesh_D Jul 04 '14 at 07:46
I Solved it.Check my answer. Silly Parse documentation – Sheraz Ahmad Khilji Jul 04 '14 at 08:06

score 1 · Accepted Answer · answered Jul 04 '14 at 08:05

I have found the solution and i must say its pretty lame of PARSE to not mention this anywhere in there documentation.

The problem was that the values that i was using inwhereContainedIn method were of type String but in reality they were pointers to another table's row. I was trying to get the values using only there ids[as it is displayed on parse] but instead i had to pass the whole object in order to retrieve them. That was the reason on why it was returning empty list.

The thing is Even though it displays IDs [pointer to object in a table] we cant search using only ID's instead we have to use complete Parse objects if we want to search a table based on Specific Object.

You can create a pointer object using just the ID using `ParseObject.createWithoutData("ClassNameHere", "objectIdHere")` as per the docs here: https://parse.com/docs/android_guide#objects-pointers — Timothy Walters, Jul 05 '14 at 08:08

Implementing OR Condition using Parse Android SDK?

2 Answers2