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