Salesforce Developer Soql Misc
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';
page revision: 1, last edited: 21 Mar 2017 16:11