Category Archives: Soql

soql

Oct 04

SOQL group by & roll up example

SELECT Status__c, count(name) cnt FROM Commercial_Contract__c WHERE Status__c NOT IN (‘Rejected’,’Draft’,’Void’,”) AND Status__c != null GROUP BY ROLLUP (Status__c)

Posted in Soql | Comments Off on SOQL group by & roll up example
Jul 05

SOQL Inner Join

select OwnerId, Owner.Name, Owner.IsActive, Owner.Email, Secondary_Owner__r.Name, Co_Owner_1__r.Name, Co_Owner_2__r.Name, Co_Owner_3__r.Name, Co_Owner_4__r.Name from Broker__c where Owner.IsActive = true

Posted in Soql | Comments Off on SOQL Inner Join
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
Mar 29

7 Traits That Distinguish Super Successful People From Ordinary Ones

By Lewis Schiff How’d Richard Branson, Bill Gates, and Warren Buffett do so well? They lived according to these seven strategic, wealth-building principles. My new book Business Brilliant is based on survey research that found seven key principles of work and wealth-building that … Read More

Posted in Administration, Development, End-User, DTV, Main, Soql | Tagged , , , , , | Comments Off on 7 Traits That Distinguish Super Successful People From Ordinary Ones