Solved

Salesforce.com:  LastModifiedDate vs. SystemModstamp

Posted on 2014-12-04
1
498 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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Entering a date in Microsoft Access can be tricky. A typo can cause month and day to be shuffled, entering the day only causes an error, as does entering, say, day 31 in June. This article shows how an inputmask supported by code can help the user a…
This article shows the steps required to install WordPress on Azure. Web Apps, Mobile Apps, API Apps, or Functions, in Azure all these run in an App Service plan. WordPress is no exception and requires an App Service Plan and Database to install
This video teaches users how to migrate an existing Wordpress website to a new domain.
Learn how to set-up PayPal payment integration in your Wufoo form. Allow your users to remit payment through PayPal upon completion of your online form. This is helpful for collecting membership payments, customer payments, donations, and more.

685 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