# 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 2019 Micro Focus or one of its affiliates | Send documentation feedback Close Send documentation feedback To open the configured email client on this computer, open an email window. Otherwise, copy the information below to a mail client, and then send this email to swpdl.idoldocsfeedback@microfocus.com. We appreciate your feedback! Product: Topic Title: Help Topic: Feedback:

_FT_HTML5_bannerTitle.htm