Solved

Salesforce.com:  LastModifiedDate vs. SystemModstamp

Posted on 2014-12-04
1
462 Views
Last Modified: 2014-12-12
Hi All

According to SF's page on System Fields, SystemModstamp gets updated 'Date and time when this record was last modified by a user or by an automated process (such as a trigger). '.

Question:  Does anyone have a definitive list of 'or by an automated process'?

Reason I ask is because I have an SSIS package connecting to SalesForce.com where each Data Source has ... 'WHERE SystemModstamp > <@User::dt_last_success>', and I'm observing that I'm getting way more rows that are reflected in a day's data entry activity. I haven't proved this yet by doing a compare of rows across days, but that might be coming.

Thanks in advance. Jim
0
Comment
Question by:Jim Horn
1 Comment
 
LVL 65

Accepted Solution

by:
Jim Horn earned 0 total points
ID: 40496156
Answered here.  

Think of anything that happens by the system AFTER a user clicks save:

Triggers
Workflow field updates
Rollup summaries causing triggers to fire
and possibly many other things.
So potentially the mod time can be > the success time if it happens slowly enough in SF to be > than the timestamp in the remote system.

And any of the above could result in changes in column values.
0

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I annotated my article on ransomware somewhat extensively, but I keep adding new references and wanted to put a link to the reference library.  Despite all the reference tools I have on hand, it was not easy to find a way to do this easily. I finall…
Shadow IT is coming out of the shadows as more businesses are choosing cloud-based applications. It is now a multi-cloud world for most organizations. Simultaneously, most businesses have yet to consolidate with one cloud provider or define an offic…
This video teaches viewers how to create their own website using cPanel and Wordpress. Tutorial walks users through how to set up their own domain name from tools like Domain Registrar, Hosting Account, and Wordpress. More specifically, the order in…
Learn how to set-up custom confirmation messages to users who complete your Wufoo form. Include inputs from fields in your form, webpage redirects, and more with Wufoo’s confirmation options.

813 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now