Documentum Connector 25.4
Documentum Connector Help

# DeleteSelectStatement

A custom query to use to find the documents that have been deleted from the repository since the last synchronize cycle. The connector runs the query once during each synchronize cycle, and it must return a list of document IDs for documents that have been deleted.

If you do not set this parameter, the connector uses the audit trail table to retrieve a list of recent modifications to the repository.

NOTE: The statement can include the placeholder `@lastruntime` to represent the time when the last synchronize cycle started. `@lastruntime` is case-insensitive.

The connector expects the query to return a column named `audited_obj_id`. If your query does not return the information using this column name, you can use an AS clause in your SQL statement. For example:

`SELECT distinct my_column_name AS audited_object_id FROM...`

Type: | String
Default: |
    SELECT audited_obj_id FROM dm_audittrail
    WHERE ((event_name = ' dm_destroy’)
      OR (event_name = ' dm_prune’))
    AND (time_stamp > date('@lastRunTime','dd/mm/yyyy hh:mi:ss'))
    ORDER BY 1
Required: | No
Configuration Section: | TaskName or FetchTasks
Example: | `DeleteSelectStatement=SELECT audited_obj_id FROM dm_audittrail WHERE ((event_name = ' dm_destroy’) OR (event_name = ' dm_prune’)) AND (time_stamp > date('@lastRunTime','dd/mm/yyyy hh:mi:ss')) ORDER BY 1`
See Also: | Incremental

Copyright 2025 Open Text
Version 25.4 | Last updated October 2025

Send documentation feedback

Close

Send documentation feedback

To send feedback using your default email client, open an email window.

Otherwise, send your feedback and the information below to MFI-swpdl.idoldocsfeedback@opentext.com.

We appreciate your feedback!

Product: Knowledge Discovery Documentum Connector 25.4

Topic Title: DeleteSelectStatement