Tag Archives: SOQL

May 02

SOQL Where IN

Select Id, StageName, Reason_Lost__c FROM Opportunity WHERE Id IN ( ‘006a000000wfxFU’, ‘006a000000vUx61’, ‘006a000000vUx7J’, ‘006a000000vUx6k’, ‘006a000000wfxXf’, ‘0063000000qxm0w’, ‘0063000000t0xDP’, ‘006a000000yCxVe’, ‘006a000000yCXkp’, ‘0063000000lYXsI’, ‘006a000000yPXz2’, ‘0063000000pbXTg’ ) select Account.Id, Account.Name From Account WHERE Account.Id IN (select AccountId From Opportunity WHERE Name like ‘Test%’)

Posted in Development, Soql | Tagged , | Comments Off on SOQL Where IN
May 02

SOQL NOT LIKE

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%’) SELECT NAME From ABC where id=:Ownerid and (NOT Name Like ‘%adviser%’);

Posted in Development, Soql | Tagged , | Comments Off on SOQL NOT LIKE
May 11

Soql inner join example “__r”

Select Name,SRID__c,Sales_Team__r.Sales_Group__c FROM Account WHERE Business_Unit_Code__c = ‘334   Select Name,SRID__c, Sales_Team__r.Name,Sales_Team__r.Sales_Group__c  FROM Account WHERE Business_Unit_Code__c = ‘334’

Posted in Development, Soql | Tagged | Comments Off on Soql inner join example “__r”