Sign Up ›

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
adi salesforceadi salesforce 

How to get the no.of records with different stagenames in opportunity.

Raj VakatiRaj Vakati
Use salesforce aggregate query as shonw below 
  
Select Count(Id),StageName from Opportunity Group By StageName

 
Akshay_DhimanAkshay_Dhiman
Hi adi salesforce,

Use This code for better understanding
  
List<AggregateResult> aggregateList =  new List<AggregateResult>();
aggregateList = [SELECT Count(Id),StageName From Opportunity Group By StageName];
System.debug('No. Of records per StageName--> '+aggregateList);



Please mark the best Answer if it helps you

Thanks
Akshay
adi salesforceadi salesforce
Hi Akshay,
Thank you for responding I have to get this requirement by using map concept  so could you try once and tell me the solution.