Tell me more ×
Salesforce Stack Exchange is a question and answer site for Salesforce administrators, implementation experts, developers and anybody in-between. It's 100% free, no registration required.
up vote 3 down vote favorite

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!

share|improve this question
@downvoter Why was this question downvoted? – ehime Mar 19 at 23:10

1 Answer

up vote 1 down vote accepted

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.

share|improve this answer
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 at 18:39
Are you just trying to get the Chatter feed? – Jesse Altman Feb 6 at 18:41
Chatter feed, group conversations, private messages etcetra – ehime Feb 6 at 18:41
Would something like this help you? salesforce.com/us/developer/docs/chatterapi/Content/… – Jesse Altman Feb 6 at 18:48
I believe it would, would this also obtain deleted items? – ehime Feb 6 at 18:54
show 2 more comments

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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