You need to sign in to do that
Don't have an account?
Mack Dsoza
Explain
10:40:46.956 (956916000)|SOQL_EXECUTE_BEGIN|[807]|Aggregations:0|
SELECT name,Goal_Profile_Type__c,Debt_Allocation__c,Account__c, Equity_Allocation__c,Gold_allocation__c,Return_expected__c
FROM
Goal_Profile__c
WHERE
account__c=:EntityId
10:40:46.960 (960252000)|SOQL_EXECUTE_END|[807]|Rows:0
Please explain me red marked statement...wht it means ?
may be u have 3 funtions but there is no result in that query ..number of rows that a query returned is 0 thats y it is showing aggregations 0 there.
All Answers
as u r not using any aggregate functions in the query ...so the result would be 0 there showing with that keyword Aggregations
But here i have used 3 aggregate function but it still shows me Aggregation as 0..
may be u have 3 funtions but there is no result in that query ..number of rows that a query returned is 0 thats y it is showing aggregations 0 there.
Thank you so much Kiran...
Odd... From execute anonymous in Eclipse the debug log show Aggregations: 0 even if there are rows in the query and the aggregation returns a real result.
try: system.debug([select sum(amount) from Opportunity]);
Doesn't matter if you have a more elaborate thing like
AggregateResult[] abc = [select name, avg(amount) from opportunity group by name];
Seems wrong to me. Best, Steve.