Apex Code Development You need to sign in to do that
Don't have an account?
shun Problems with query in 3.0 API using "not" operator
Hi,
I did a few queries on the Account object using the 3.0 API with the "not" operator and the following cases do not seem to work:
1) where not Name = 'abc' // returns 0 results even though Name != 'abc' returns some results
2) where not Name like 'abc%' // accounts whose Name does not start with 'abc' are not returned.
Is this a bug with the "not" operator?
Shun
I did a few queries on the Account object using the 3.0 API with the "not" operator and the following cases do not seem to work:
1) where not Name = 'abc' // returns 0 results even though Name != 'abc' returns some results
2) where not Name like 'abc%' // accounts whose Name does not start with 'abc' are not returned.
Is this a bug with the "not" operator?
Shun
Hi Shun,
As stated in the doc, the Not operator is only appropriate for boolean values.