Activities on Contacts

  • 1
  • Question
  • Updated 4 years ago
  • Answered
I need to be able to list all Activities related to a contact when I use Task model not all activities are listed on the the contact. Does anyone knows which object I should be using?
Photo of Andrew Ottaru

Andrew Ottaru

  • 412 Points 250 badge 2x thumb

Posted 4 years ago

  • 1
Photo of Rob Hatch

Rob Hatch, Official Rep

  • 44,006 Points 20k badge 2x thumb
Activities include tasks and events.  Unfortuately Salesforce will not let us query the OpenActivities and ActivityHistory sObjects.  So you are forced to use two tables.  One will be tasks and the other will be events. 

Its all we can do. Sorry. 
Photo of Andrew Ottaru

Andrew Ottaru

  • 412 Points 250 badge 2x thumb
Thank you Rob, Even when I use two objects Task and Event not all activities are listed. Do you know why this is?
Photo of Benton Cotter

Benton Cotter

  • 302 Points 250 badge 2x thumb
We also have an issue with task list. It will not show tasks past a deactivated user. So if a deactivated completed a task on April 1, 2013, the task list will stop at that date. Happens on multiple records and object types.
Photo of Ben Hubbard

Ben Hubbard, Employee

  • 12,470 Points 10k badge 2x thumb
The tasks may have been marked as "Archived" by salesforce.  Have you tried checking the "Query Deleted / Archived records" checkbox in the "Advanced" section of the model properties?
Photo of Benton Cotter

Benton Cotter

  • 302 Points 250 badge 2x thumb
that worked!! thanks Ben