Salesforce Developer Soql Misc

salesforce-developer-soql

List<OpportunityContactRole> contactRoles = [
  SELECT Id, OpportunityId
  FROM OpportunityContactRole
  WHERE OpportunityId = :o.Id
];

SELECT Id FROM Account WHERE Id IN (SELECT AccountId FROM Opportunity) AND
Id IN :Trigger.old

SELECT Id,(SELECT Id FROM Opportunities) FROM Account WHERE Id IN :Trigger.New

SELECT NAME,ID,(SELECT NAME FROM OpportunityLineItem) FROM OPPORTUNITY WHERE ID = '0066C000002FhLn'
SELECT NAME,ID,Opportunity_Product_Groups__c FROM OPPORTUNITY WHERE ID = '0066C000002FhLn'
SELECT NAME,Description, UnitPrice,Product_Group__c,Id FROM OpportunityLineItem WHERE OpportunityId = '0066C000002FhLn'
SELECT NAME,Description, UnitPrice,Product_Group__c,Id FROM OpportunityLineItem WHERE OpportunityId = '0066C000002FhLn'

OpportunityLineItem p = [SELECT UnitPrice FROM OpportunityLineItem WHERE Id='00k6C000003G1yvQAC'];
p.UnitPrice = 15000;
update p;

// Adding a product to an opportunity
Account acc = new Account(Name = 'Test');
insert acc;
Opportunity oppObj = new Opportunity(
  Name = 'TestOpp',
  AccountID = acc.Id,
  Amount = 2000,
  CloseDate=Date.today(),
  StageName='Close Won',
  Type='New Customer');
insert oppObj;
Product2 newProd = new Product2(Name = 'test product', family = 'test family');
insert newProd;
PriceBookEntry pbEntry = new PriceBookEntry(
    UnitPrice = 300,
    PriceBook2Id = [select id from PriceBook2 where isStandard = true].Id,
    Product2Id = newProd.Id,
    IsActive = true);
insert pbEntry ;
OpportunityLineItem oppLine = new OpportunityLineItem(pricebookentryid=pbEntry.Id,TotalPrice=2000,Quantity = 2,OpportunityID = oppObj.Id);
insert oppLine;

SELECT ID,
  Opportunity.Pricebook2Id, 
  Inserted__c,
  Opportunity.Contract_Start_Date__c, 
  Product2Id,
  Product2.Bundle__c,
  ServiceDate, 
  opportunityid, 
  Quantity, 
  Opportunity.Multiyear_Opp_Sequence__c 
FROM OpportunityLineItem 
WHERE ID in : trigger.newmap.keyset()

Map<Id,Product2> prod = new Map<Id,Product2>([
  select Id,of_Licenses__c,Term_Months__c,Product_Generation__c 
  from Product2 where Id in :prodIds
]);

Map<Id,Opportunity> Opp = new Map<Id,Opportunity>([
  select Id,Contract_Start_Date__c f
  rom Opportunity where Id in :opIds
]);

List<Product_Bundle__c> ProdBund = [
  SELECT ID,Product__r.Name, Name, 
    (SELECT ID,Product__c,Product__r.Name, Quantity__c 
     FROM Products__r) 
  FROM Product_Bundle__c WHERE Product__c =: pBunID
];

List<Opportunity> OppList = [
  SELECT ID, Name, Multiyear_Total__c, Multiyear_Opp_Sequence__c, Pricebook2Id 
  FROM Opportunity
  WHERE ID =: OppID
];

SELECT ID, Pricebook2Id, UnitPrice, Product2Id 
FROM PricebookEntry 
WHERE Product2Id IN: bProdIDList AND Pricebook2Id =: PriceBook
SELECT Id FROM Account WHERE Name LIKE 'Bob\'s BBQ';

WHERE BooleanField = TRUE
WHERE BooleanField = FALSE
// Salesforce - Developer - SOQL - Aliases:

We can use alias notation in SOQL:

SELECT count()
FROM Contact c, c.Account a
WHERE a.name = 'MyriadPubs';
Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License