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