You need to sign in to do that
Don't have an account?
arasu
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%'.
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%'
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!
Refer to io games (https://iogames.onl) list games new 2022
Refer to io games (https://agario.boston) New Game I can recommend.
Best Regards
Savevideo.red (https://savevideo.red/en)
I am gonna pass this to my team to use it accordingly for our project of porcsi - TPMS Supplier (https://porcsi.com/).