function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion

Problems with query in 3.0 API using "not" operator


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?


Hi Shun,

As stated in the doc, the Not operator is only appropriate for boolean values.