Questions tagged [group-by-rollup]
The group-by-rollup tag has no usage guidance.
6
questions
1
vote
2answers
49 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 &...
0
votes
1answer
49 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, ...
2
votes
1answer
42 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
1answer
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, ...
1
vote
2answers
173 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
1answer
429 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 ...