[SalesForce] Modify the results of an aggregate result directly

I need to add a variable to an Aggregate Result list.

In the semi pseudocode below I attempt to assign a value to the AggregateResult[] if the sum is 0.

This does not work. The aggRes is later used in a function and I do not want to have to put the results of the aggregate result into a map for a solution.

Is it possible to accomplish what I'm doing and directly modify the AggregateResult?

AggregateResult[] aggRes = [Select Expense__c, Sum(Cost__c) from CustomObject__c Group By Expense__c]; 

for(AggregateResult ar: aggRes) {
    if(ar.get(Cost__c) == 0) {
        ar.put(Cost__c, 10);
    }
}

Best Answer

No. If you attempt to modify the AggregateResult, you'll get a runtime error. Here's an example from my dev org:

AggregateResult[] ar = [select name name from account group by name];
System.debug(ar[0]);
ar[0].put('name','Test2');
System.debug(ar[0]);

Result:

EXECUTION_STARTED

CODE_UNIT_STARTED|[EXTERNAL]|execute_anonymous_apex

LIMIT_USAGE|[1]|SOQL|1|100

LIMIT_USAGE|[1]|AGGS|0|300

LIMIT_USAGE|[1]|SOQL_ROWS|69|50000

ENTERING_MANAGED_PKG|

USER_DEBUG|[2]|DEBUG|AggregateResult:{name=,}

ENTERING_MANAGED_PKG|

EXCEPTION_THROWN|[3]|System.SObjectException: Invalid field name for AggregateResult

FATAL_ERROR|System.SObjectException: Invalid field name for AggregateResult

The documentation also states that the object is read-only, so it is not possible to modify the values within the result object.

AggregateResult is an sObject, but unlike other sObject objects such as Contact, it is read-only and it is only used for query results.

Related Solutions

[SalesForce] Split a single field into 2 columns for a VF page

This is untested so you may need to have play, however this should return a List of the RevenueWrapper classes which contains the 4 columns you are looking to use in your VF page:

public class RevenueController{

Map<String, RevenueWrapper> ResultList = new Map<String, RevenueWrapper>(); 

public RevenueController(){
    List<AggregateResult> result =  [
    SELECT FISCAL_YEAR(Date__c) Date, Type__c, sum(Amount__c) Amount
    FROM Revenue__c
    GROUP BY FISCAL_YEAR(Date__c), Type__c];

    for(AggregateResult ar : result){

        RevenueWrapper RW = new RevenueWrapper();

        //If the RevenueWrapper already exists grab it from the Map
        if(ResultList.containsKey(String.valueOf(ar.get('Date')))){
            RW = ResultList.get(String.valueOf(ar.get('Date')));
        }

        //Set the amount
        RW.setAmount(ar);

        //Save back to the Map
        ResultList.put(String.valueOf(ar.get('Date')), RW);
    }
}

public List<RevenueWrapper> getResults() {
    return ResultList.values();
}


public class RevenueWrapper{
    public String revenueDate { get; set; }
    public Integer budgetAmount { get; set; }
    public Integer actualAmount { get; set; }
    public Integer varianceFYPercent { set; }
    public Integer varianceFYAmount { set; }

    public RevenueWrapper(){

    }

    public void setAmount(AggregateResult ar){
        revenueDate = String.valueOf(ar.get('Date'));

            //Set the amount value based on type
        if(ar.get('Type__c') == 'Budget'){
            budgetAmount = Integer.valueOf(ar.get('Amount'));
        }else if(ar.get('Type__c') == 'Actual'){
            actualAmount = Integer.valueOf(ar.get('Amount'));
        }else{ //Catch all for a type that isn't recognised
            return;
        }

    }

    public Integer getVarianceFYAmount(){
        return actualAmount - budgetAmount;
    }

    public Decimal getVarianceFYPercent(){
        if(budgetAmount != 0){
            return Decimal.valueOf((Double.valueOf(actualAmount) / Double.valueOf(budgetAmount)) * 100).setscale(1);
        } else{
            return 0;
        }
    }
}

}

[SalesForce] toLabel() in aggregate query

SELECT toLabel(Equipment__r.technical_Platform__c) aliasTECPROB FROM Maintenance_Schedule__c GROUP BY Equipment__r.technical_Platform__c

Use Alias it will work out

Best Answer

Related Solutions

[SalesForce] Split a single field into 2 columns for a VF page

[SalesForce] toLabel() in aggregate query

Related Topic