Apex Code Development You need to sign in to do that
Don't have an account?
arasu Does SOQL support "NOT LIKE" operator?
Hi,
I want to write a query like this:
select Account__r.Id,Account__r.Name,Account__r.Account_Country__c from Card_UPC__c where Account__r.partner_relationship_status__c='Allow Relationships To Be Created' and Account__r.Name not like 'Test%'.
The above query throws SOQL exception.
It works and runs when I remove the NOT operator as shown below:
select Account__r.Id,Account__r.Name,Account__r.Account_Country__c from Card_UPC__c where Account__r.partner_relationship_status__c='Allow Relationships To Be Created' and Account__r.Name like 'Test%'
My questions is: Does SOQL support "NOT LIKE" operator. If no, then what is the alternative to achieve a similar operation.
Thanks for all your feedbacks.
Ambili
Hi Simon,
Thanks for your response. Actually the brackets were missing. The following SOQL works fine:
select Account__r.Id,Account__r.Name,Account__r.Account_Country__c from Card_UPC__c where Account__r.partner_relationship_status__c='Allow Relationships To Be Created' and (NOT Account__r.Name like 'Test%').
Thanks,
Ambili
All Answers
not foo__c like 'bar%'
Hi Simon,
Thanks for your response. Actually the brackets were missing. The following SOQL works fine:
select Account__r.Id,Account__r.Name,Account__r.Account_Country__c from Card_UPC__c where Account__r.partner_relationship_status__c='Allow Relationships To Be Created' and (NOT Account__r.Name like 'Test%').
Thanks,
Ambili
I found it very useful, Thanks!