-
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 6 years, 11 months ago by
yash ghatge.
-
This discussion was modified 6 years, 10 months ago by Forcetalks.
-
This discussion was modified 6 years, 10 months ago by Forcetalks.
-
This discussion was modified 6 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
How to Run Customer Success and SaaS Sales in Salesforce
If you sell physical products using a traditional sales model, a Customer Relationship Management (CRM) platform like Salesforce should deliver all the value you need…
What is the Salesforce Guidance Center in 2023? | The Trailhead Guide
The Guidance Center is a one-stop shop for learning and enablement in the flow of work. Learning is both recommended to users automatically by Salesforce…
Top Salesforce Spring '23 Experience Cloud Features
Salesforce Experience Cloud focuses on accelerating deployment, saving time, fostering great customer engagement, enhancing security, boosting productivity, and fostering collaboration. Let's have a look at…
Popular Salesforce Videos
How To Set Up A Site On Salesforce | Salesforce Development Tutorial
Learn how to set up a site on Salesforce. This tutorial will cover the following points - 1. Create Public Websites Choose a branded URL…
How To Assign Leads in Salesforce | Overview of 3 Main Lead Routing Solutions
Salesforce offers several options on how to automatically assign incoming leads to a suitable sales manager. But what to choose: out-of-the-box features, external AppExchange app,…
What Are Roll-Up Summary Fields in Salesforce? | Video Tutorial
A roll-up summary field calculates values from related records, such as those in a related list. You can create a roll-up summary field to display…
