Questions tagged [group-by-rollup]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
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 ...