-
how to count open cases against owner id by map in Salesforce?
list<AggregateResult> result = ([select ownerid,count(id)total from case where isclosed = false group by ownerid]);
map<id,integer> mapresult = new map<id,integer>
For (AggregateResult aggresult : result)
{
mapresult.put(aggresult.get(aggresult.ownerd),aggresult.get(total) )
-
This discussion was modified 5 years, 11 months ago by
yash ghatge.
-
This discussion was modified 5 years, 10 months ago by
Forcetalks.
-
This discussion was modified 5 years, 10 months ago by Forcetalks.
-
This discussion was modified 5 years, 11 months ago by
-
1 Reply
-
You can also explore report features here. Summary report on case to display only open cases and then group it by owner names.
Log In to reply.
Popular Salesforce Blogs
Avoiding Race Conditions
An action function provides a way to submit a form programmatically via a JavaScript function call. When an action function is executed from a JavaScript event…
Marketing Cloud: Single Send Journeys versus Send Flows
If you have used Journey Builder recently, you probably noticed that Salesforce Marketing Cloud has introduced a new feature called “Single Send Journey”. This is…
Take Customer Experience a notch up with Salesforce Einstein AI
Salesforce Einstein AI is the next-gen Artificial Intelligence platform available within your Salesforce CRM data. It analyses your existing data, gives you smart predictions, actionable…
Popular Salesforce Videos
Salesforce - How to Create and Debug Process Builders
Check out this video on how to debug Process Builders. Once you really get into building processes in Salesforce in can be confusing as to…
Salesforce — How To Improve Customer Service for Small Businesses
How can a small business improve its customer service? More than ever before, supporting customers is key to a small business's survival — so give…
Salesforce Einstein Keynote: AI for CRM
Salesforce Einstein is delivering more than one billion predictions every day, helping companies get a new level of insight about their business and their customers.…
