I have to get the open activities, closed activities on case objects. I am having no idea how to get started with it. Can someone guide me on that.

I know that we have Activities History and Open Activities are there on case Object list but I am not able to access them.

  • are you trying to run a report to get the list of open/close activities ? or do you need this in code somehere ? Aug 13 '14 at 4:56
  • I have to run a report on the basis of open and closed activities classifying them on the basis of Email and phone call, with both incoming and outgoing activities Aug 13 '14 at 4:57
  • In a comment below, you ask how to do it programmatically, do you just want a SOQL query that will give you this? Aug 13 '14 at 10:50

You can do the following to get this..

  • Go to Reports Tab -> Click on New Report
  • Select Activities with Cases report
  • In the report builder screen, use the filters section to Select All Activities , both open and closed
  • Change your report format to Summary and group by Case number if you want
  • add the required columns, Activity Type (phone/email), Status, etc.. from the left panel into the report columns
  • Can we do it programmatically Aug 13 '14 at 9:13
  • Use the following : SELECT Id,Subject from OpenActivities Where WhatId= "required_id" Oct 16 '14 at 7:56

Create the report and add a filter for case id, but leave it blank. Then add a button to your case page layout that calls the report and passes in the case id.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.