Questions tagged [group-by-rollup]
The group-by-rollup tag has no usage guidance.
7 questions
1
vote
1
answer
190
views
group by rollup: identify subtotals rows
in this Apex code,
List<AggregateResult> agr = [
SELECT LeadSource, Rating, COUNT(Name) cName
FROM Lead
GROUP BY ROLLUP (LeadSource, Rating)
];
for(AggregateResult r : agr){
...
- 33
2
votes
2
answers
592
views
GROUP BY ROLLUP gives labels as Null in SOQL Query
I am using GROUP BY ROLLUP in query to get totals & subtotals of aggregate columns.But while the result of total & subtotals are displayed i am getting their labels as Null instead of Total &...
- 536
0
votes
1
answer
158
views
How to identify similar records in a List and then updating corresponding fields
trigger setCertificationToFailed on Exam__c (after update) {
List<Exam__c> ExamList = new List<Exam__c>();
ExamList = [SELECT Id, Exam_id__c, Exam_state__c, doNothingExam__c, ...
- 161
2
votes
1
answer
45
views
how to create a salesforce rollup field thats not on a master record in pro edtion
I have a object called key account with all the accounts that belong to this key account connected - the connected accounts have a sales total field which i what to add into a total on the Key account,...
2
votes
1
answer
1k
views
GROUP BY / ROLLUP Query Rows
Why does using GROUP BY ROLLUP multiply the number of query rows returned by the number of fields you are rolling up + 1?
Example:
I have 3408 records in the database. If I run:
[SELECT Sex__c, ...
- 21
1
vote
2
answers
177
views
Helper Class Error - Grouping in Aggregate
I don't get an error in the console, but for the below helper class but when I edit my record I get this error on save:
"Error:Apex trigger RoomTypeTrigger caused an unexpected exception, contact ...
9
votes
1
answer
461
views
Group by Rollup: Visualforce Remoting Exception: Too many query rows: 1000001
I have 557,029 Foo objects in my org. I want to count how many of each kind of picklist value there are within these:
Type 1 - 100,000
Type 2 - 60,000
Type 3 - 40,000
Type N - N
I thought I could ...
- 2,740