Documentum Connector 25.4
Documentum Connector Help

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

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