# CustomFieldSelectStatement

A SELECT statement to use to extract metadata from the Documentum repository when a document is retrieved.

The SELECT statement should include the placeholder `@r_object_id` to represent the `r_object_id` for the document. Specify a complete SELECT statement including the SELECT, FROM, ORDERBY, and WHERE clauses.

To run multiple queries, for example when multiple statements are needed to extract the required fields, you can use numbered parameters. For example, set `CustomFieldSelectStatement0`, `CustomFieldSelectStatement1` and so on.

To take the results of the specified queries and write the information into the documents, use the configuration parameters `CustomFieldExtractNameN` and `CustomFieldExtractToNameN`.

`CustomFieldExtractNameN` specifies the name of a result column from one or more of the queries. The corresponding `CustomFieldExtractToNameN` specifies the name of the document field in which to write the result value(s).

Type: | String
Default: |
Required: | No
Configuration Section: | TaskName or FetchTasks
Example: | `CustomFieldSelectStatement=SELECT r_modify_date FROM dm_document WHERE r_object_id='@r_object_id'`
See Also: | CustomFieldExtractNameN CustomFieldExtractToNameN

_FT_HTML5_bannerTitle.htm