AGG_MAX

Description

Performs a dynamic aggregation on a specified Salesforce object and returns the maximum value of a specified field among all matching records.

Syntax

AGG_MAX(aggregate_object_name, aggregate_field_name, ...[group_field_name, group_field_value], additional_filters_optional) -> Decimal

Parameters

ParameterData TypeRequiredDescription
aggregate_object_nameStringYesThe name of the object containing records to evaluate.
aggregate_field_nameStringYesThe name of the numeric field whose maximum value will be returned.
… group_field_nameStringNoThe name of the field used to filter records.
… group_field_valueObjectNoThe field value used as filtering criteria.
additional_filters_optionalStringNoAdditional conditions to filter records.

Examples

AGG_MAX(
	"Opportunity", 
	"Amount", 
	"AccountId", Id, 
	"StageName = 'Closed Won'"
)
-- Returns the maximum Amount from Opportunity records grouped by AccountId, filtered by StageName = "Closed Won", where Opportunity.AccountId matches the Id from the source records.

-- At runtime, DSP generates the following SOQL query:
SELECT AccountId groupField0, MAX(Amount) agg0 
FROM Opportunity 
WHERE AccountId IN ('0018K00000kPuYXQA0', '0018K00000kPuYYQA0', '0018K00000kPuYZQA0', '0018K00000kPuYaQAK', '0018K00000kPuYbQAK') AND StageName = 'Closed Won' 
GROUP BY AccountId
AGG_MAX(
	"Opportunity", 
	"Amount", 
	"AccountId", Id, 
	"OwnerId", OwnerId, 
	"StageName = 'Closed Won'"
)
-- Returns the maximum Opportunity Amount grouped by AccountId and OwnerId, filtered by StageName = "Closed Won", where Opportunity.AccountId and Opportunity.OwnerId match the corresponding values from the source records.

-- At runtime, DSP generates the following SOQL query:
SELECT AccountId groupField0, OwnerId groupField1, MAX(Amount) agg0 
FROM Opportunity 
WHERE (AccountId IN ('0018K00000kPuYXQA0', '0018K00000kPuYYQA0', '0018K00000kPuYZQA0', '0018K00000kPuYaQAK', '0018K00000kPuYbQAK') AND OwnerId IN ('005D2000006JY2bIAG', '0058K0000047WdvQAE', '0055e000007rpICAAY')) AND StageName = 'Closed Won'
GROUP BY AccountId, OwnerId

Related information