Open topic with navigation

# 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

© 2018 Micro Focus or one of its affiliates | Send documentation feedback to Micro Focus Close Send documentation feedback To open the configured email client on this computer, open an email window. Otherwise, copy the information below to a web mail client, and send this email to swpdl.idoldocsfeedback@microfocus.com. We appreciate your feedback! Product: Topic Title: Help Topic: Feedback:

_FT_HTML5_bannerTitle.htm