SelectStatement

The SQL query to use to retrieve documents from the Documentum repository.

The statement should return a single column named r_object_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 my_column_name AS r_object_id ...

When you use this parameter, the other parameters that can be used to configure parts of the default statement are ignored.

NOTE: You can use @lastruntime to represent the last run time in the format dd/mm/yyyy hh:mi:ss. @lastruntime is case-insensitive.

Type: String
Default:  
Required: No
Configuration Section: TaskName or FetchTasks
Example: SelectStatement=SELECT DISTINCT(dm_document.r_object_id) FROM dm_document
See Also: