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

_FT_HTML5_bannerTitle.htm