DeletedStatement

The SQL statement to use to find deleted 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: DeletedStatement=select * from table where deleted=1
See Also:

InitialStatement

AddedAndUpdatedStatement

LastRunTimeFormat

UseIncrementalStatements