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: |