Re: Queries used by a Map of Scribe Online Solutions -- the Net Change has options:
(1) Process all records on each run, and
(2) clearing the "Most Recent Record Processed Date"
What is the impact of these options? Are they used to reconcile data?
When you are using option one, the Agent will always process every record available within your specified filter criteria. In an on going integration, let's say every 30 minutes, you would be 'reprocessing' all your data every time.
This is not very efficient for those scenario's, so you would want to apply a NetChange filter on a Last Modified Date Time stamp. So you only process the new or the modified records since the last run.
The moment you apply the NetChange filter, the initial run will grap all the data (based on your filter criteria of course) and determine the Last Run Date Time for the Agent.
When you click the button 'Clearing the most recent record processed date', you are resetting the LastRunDataTime. So the Agent will grab all data again.