DocumentumForums.com

select r_object_id, r_workflow_id, r_act_seqno , r_creation_date, r_runtime_state from dmi_workitem where r_workflow_id in( select distinct(r_workflow_id) from dmi_package where any r_component_id like '0b027%' and any r_component_id in( select r_object_id from <custom object> where <attribute> = 'x...

SELECT object_name, SCORE
FROM dm_document
WHERE SEARCH DOCUMENT CONTAINS 'documentum forums'

1. The SEARCH clause enables searching the full-text index. 2. The keywords SCORE and SUMMARY can be used in the selected values list: a. The SCORE keyword returns the document's relevance ranking as determined by the Index Server. A higher relevance ranking implies a better match. By default, the r...