You need to sign in to do that
Don't have an account?
dipu2
Cannot figure out what is wrong in this SOQL WHERE clause combining NOT LIKE with another clause?
[SELECT Id, Name, AccountId FROM Contact WHERE NOT(Name LIKE '%orbs%') AND AccountId='001E000000M4pZEIAZ' LIMIT 4]
Cannot figure out what is wrong in this SOQL WHERE clause combining NOT LIKE with another clause?
Try this...
SELECT Id, Name, AccountId FROM Contact WHERE (NOT Name LIKE '%orbs%') AND (AccountId='001E000000M4pZEIAZ') LIMIT 4