Is there a way to create an "end of day summary" of a user(s)? It would be something to the effect of a dump of all their conversation history, posts, likes etcetra. I'm using PHP as a serverside so SOQL code would probably be all I'd need, not the Java portion =)


  • @downvoter Why was this question downvoted?
    – ehime
    Mar 19 '13 at 23:10

As far as I know, this isn't something that is going to be very easy to do within Salesforce. Are you looking to get all of their actions, such as when the login, create records, edit records, etc or are you just looking to get a history of their chatter?

To get a list of all of their actions, you are going to need several SOQL calls to call each object type with a where clause like:

WHERE (CreatedDate = TODAY AND CreatedBy = :userId) OR (LastModifiedDate = TODAY AND LastModifiedBy = :userId)


You will need to run a SELECT statement on every object that you are looking to get this for. It isn't going to be a simple process unfortunately.

  • We're really looking for the full shebang on a daily basis, the company I work for is a data warehouse, so that was really the real goal when it came to using Chatter =(
    – ehime
    Feb 6 '13 at 18:39
  • Are you just trying to get the Chatter feed? Feb 6 '13 at 18:41
  • Chatter feed, group conversations, private messages etcetra
    – ehime
    Feb 6 '13 at 18:41
  • Would something like this help you? salesforce.com/us/developer/docs/chatterapi/Content/… Feb 6 '13 at 18:48
  • I believe it would, would this also obtain deleted items?
    – ehime
    Feb 6 '13 at 18:54

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.