Search code examples
salesforcesoql

SalesForce SOQL MALFORMED_QUERY

Why is this SOQL query returning MALFORMED_QUERY: unexpected token: on

Select id FROM account 
where id = '0012000000I7MkRAAV' or id = '0012000000I7MkRAAV' 
and id = '0012000000I7MkRAAV'

Changing "and" to "or" returns the result just fine:

Select id FROM account 
where id = '0012000000I7MkRAAV' or id = '0012000000I7MkRAAV' 
or id = '0012000000I7MkRAAV'

I am executing the query in Force explorer.

Solution

  • You need to group your and/or's so that its not ambiguous, e.g.

    Select id FROM account where id = '0012000000I7MkRAAV' or (id = '0012000000I7MkRAAV' and id = '0012000000I7MkRAAV')