3

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 =)

Thanks!

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

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)

http://www.salesforce.com/us/developer/docs/api/Content/sforce_api_calls_soql_select_dateformats.htm

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? – Jesse Altman 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/… – Jesse Altman 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.