Documentum Connector 24.2

# 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

Copyright 2024 Open Text
Version 24.2 | Last updated March 2024

Send documentation feedback

Close

Send documentation feedback

To send feedback using your default email client, open an email window.

Otherwise, send your feedback and the information below to MFI-swpdl.idoldocsfeedback@opentext.com.

We appreciate your feedback!

Product: IDOL Documentum Connector 24.2

Topic Title: CustomFieldSelectStatement