Skip to main content
Salesforce

Return to Question

added 49 characters in body
Source Link
Oleksandr Berehovskyi
Oleksandr Berehovskyi
  • 18.8k
  • 4
  • 46
  • 65

I have this Apex SOQL query:- Map<Id,AggregateResult> results=new Map<id,AggregateResult>([select accountid id,min(id),min(Partner_Admin_Sequence_Number__c) Integer from Contact where AccountId IN:deactconacctSet and Contact_Status__c ='Active' and (Partner_Admin_Sequence_Number__c !=null and Partner_Admin_Sequence_Number__c!=0) group by accountid]);

Map<Id, AggregateResult> results = new Map<Id, AggregateResult>([
    select accountid id, min(id), min(Partner_Admin_Sequence_Number__c) Integer 
    from Contact
    where AccountId IN:deactconacctSet and Contact_Status__c ='Active' and (Partner_Admin_Sequence_Number__c !=null and Partner_Admin_Sequence_Number__c!=0)  group by accountid
    ]);

I have this Apex SOQL query:- Map<Id,AggregateResult> results=new Map<id,AggregateResult>([select accountid id,min(id),min(Partner_Admin_Sequence_Number__c) Integer from Contact where AccountId IN:deactconacctSet and Contact_Status__c ='Active' and (Partner_Admin_Sequence_Number__c !=null and Partner_Admin_Sequence_Number__c!=0) group by accountid]);

I have this Apex SOQL query:

Map<Id, AggregateResult> results = new Map<Id, AggregateResult>([
    select accountid id, min(id), min(Partner_Admin_Sequence_Number__c) Integer 
    from Contact
    where AccountId IN:deactconacctSet and Contact_Status__c ='Active' and (Partner_Admin_Sequence_Number__c !=null and Partner_Admin_Sequence_Number__c!=0)  group by accountid
    ]);
Source Link
moni gangireddy
moni gangireddy
  • 39
  • 1
  • 4

AggregateResult throws error: System.ListException: Row with null Id at index: 0

I have this Apex SOQL query:- Map<Id,AggregateResult> results=new Map<id,AggregateResult>([select accountid id,min(id),min(Partner_Admin_Sequence_Number__c) Integer from Contact where AccountId IN:deactconacctSet and Contact_Status__c ='Active' and (Partner_Admin_Sequence_Number__c !=null and Partner_Admin_Sequence_Number__c!=0) group by accountid]);