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