Selecting data via backendless

Hi.
So I have problem with select data from db. I’m trying to get some users with same settings in columns. I’m doing like this:

StringBuilder whereClause = new StringBuilder();
whereClause.append("objectId != '" + SharedPrefs.getObjectId(context) + "'");
whereClause.append(" and ");
whereClause.append("gender = '" + gender + "'");
whereClause.append(" and ");
whereClause.append("bodybuilding = " + bodyBuilding);
whereClause.append(" or ");
whereClause.append("crossfit = " + crossfit);
whereClause.append(" or ");
whereClause.append("mma = " + mma);
whereClause.append(" or ");
whereClause.append("fitness = " + fitness);

And I want to get users who have for example:
0. object id - all users that not match my object id.

  1. gender = male
  2. bodybuilding = true
  3. crossfit = true
  4. mma = false
  5. fitness = false

and I always getting users who don’t have any of boolean variables, so they are all false, or instead of gender - male, got female users and I always got my account in the list of users…

Help please understand how to select userrs correctly.

Hi, Gleb!

The easiest way to check your queries is by using our REST console:
After that you can try the same queries with SDK requests
http://image.prntscr.com/image/804d6c8103d248f783f8f208a8843db0.png</img>