AddedAndUpdatedStatement

The SQL statement to use to find new and updated records when UseIncrementalStatements=True.

When UseIncrementalStatements=True, the connector runs the queries specified by InititalStatement, AddedAndUpdatedStatement and DeletedStatement instead of the query specified by the SQL parameter.

When UseIncrementalStatements=False, this parameter is ignored.

The string @lastruntime is replaced with the time of the last successful synchronize. The last run time is stored using GMT. If the dates in the database table differ from GMT, you can use the DATE_SUB() and DATE_ADD() functions to modify the last run time as required.

Type: String
Default:  
Required: No
Configuration Section: TaskName or FetchTasks
Example: AddedAndUpdatedStatement=select * from table where lastmodified > '@lastruntime'
See Also:

InitialStatement

DeletedStatement

LastRunTimeFormat

UseIncrementalStatements