Follow us Question: setWhereClause

General
1

Hi,

I have a follow up question of [this question]. Can I set multiple where clauses?

Regards
Rhonwen

2

I see I can put an extended string.

When I put in the following:

builder.setWhereClause("email != '" + Backendless.UserService.CurrentUser().getEmail() + "'" + "AND staffType = 'Default

…It does not work.

3

I tried to repeat the where clause.

See code below:

builder.setWhereClause("email != '" + Backendless.UserService.CurrentUser().getEmail() + "'");
builder.setWhereClause("accepted = '" + query + "'");

…does not work. gets overridden by last where clause

4

You can assign only one where clause. Your whereClause may contain AND/OR logical operators to have multiple conditions, but there must be only one whereClause query statement.

Regards,
Mark

5

I did that and it did not work, But I sorted it out with an if statement. No need for multiple conditions in the where clause anymore.

Thank you for the Help. Maybe I did something wrong. It is quite possible since I worked through the night on my app.

Kind Regards
Rhonwen

6

I missed a single quotation after 'DEFAULT ’ and a space before the ‘AND’ operator.