Activity Forums Salesforce Questions and Answers how to count open cases against owner id by map in Salesforce?

  • how to count open cases against owner id by map in Salesforce?

  • yash ghatge

    Member
    December 31, 2018 at 8:13 am

    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 1 year, 5 months ago by  yash ghatge.
    • This discussion was modified 1 year, 4 months ago by  Forcetalks.
    • This discussion was modified 1 year, 4 months ago by  Forcetalks.
  • Jade

    Member
    January 30, 2019 at 10:26 am

    You can also explore report features here. Summary report on case to display only open cases and then group it by owner names.

     

Viewing 1 - 2 of 2 posts

Log In to reply.





Popular Salesforce Blogs

Popular Salesforce Videos