AGGREGATION GENERAL

Description

DSP optimizes performance by reducing SOQL queries, combining multiple mergeable aggregate functions into a single query whenever possible.

Example

AGG_AVG("Opportunity", "Amount", "AccountId", Id, "StageName = 'Closed Won'")
AGG_SUM("Opportunity", "Amount", "AccountId", Id, "StageName = 'Closed Won'")
AGG_COUNT("Opportunity", "Id", "AccountId", Id, "StageName = 'Closed Won'")

-- DSP merges these into one SOQL query:
SELECT AVG(Amount) agg0, SUM(Amount) agg1, COUNT(Id) agg2, AccountId groupField0 
FROM Opportunity 
WHERE AccountId IN ('0018K00000kPuYXQA0','0018K00000kPuYYQA0','0018K00000kPuYZQA0','0018K00000kPuYaQAK','0018K00000kPuYbQAK') AND StageName = 'Closed Won' 
GROUP BY AccountId