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.
- gender = male
- bodybuilding = true
- crossfit = true
- mma = false
- 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.