You need to sign in to do that
Don't have an account?

SOQL where clause on boolean does not work??
I am using the schema browser in the force.com IDE. I wanted to see all of the profiles where the attribute PermissionsMangeCases was set to true. I used the SOQL query below, but something is not right with the results. Is there a bug?
This returns all profiles where PermissionsManageCases is true and false
SELECT Name, PermissionsManageCases from profile
where PermissionsManageCases = false
where PermissionsManageCases = false
This does not return anything (and based on the above query, there are several profiles where this attribute is true)
SELECT Name, PermissionsManageCases from profile
where PermissionsManageCases = true
where PermissionsManageCases = true