Multiple whereClause conditions for query

General
1

I am trying to query for two conditions:

"members.objectId = '\(user.objectId)' AND group == false"

It works fine when I just use the first half of the clause, but when I tacked on AND group == false I receive an error back saying the clause is invalid.

Am I chaining them together correctly? Am I checking the boolean group incorrectly?

2

Use single equals sign:

group = false

3

Well for me AND is not working in the where clause…

objectId NOT IN (’"+last_question_id+"’) and category = '5C595EC5-284A-F0A3-FFAF-6874E731B000’I am not getting any results

4

I tried this:

BackendlessDataQuery dataQuery_set_random = new BackendlessDataQuery();
QueryOptions queryOptions_random = new QueryOptions();
queryOptions_random.setPageSize(1);
queryOptions_random.setOffset(get_object_num);
dataQuery_set_random.setQueryOptions(queryOptions_random);
String whereClause_getQuestion = “category IN (‘5C595EC5-284A-F0A3-FFAF-6874E731B000’)”;
dataQuery_set_random.setWhereClause(whereClause_getQuestion);

BackendlessCollection<Map> result_random_question = Backendless.Persistence.of(“Question”).find(dataQuery_set_random);
int randDataSize = result_random_question.getData().size();

I am getting 0 results. However if I tried in the SQL search data browser then I can see the results. What could be the problem?

5

Hi, vikzilla. Could you please provide app id so that i can try your example on your application.

6

This one I found the issue…