O'Reilly logo

Documentum 6.5 Content Management Foundations by Pawan Kumar

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Help—some DQL Queries

The queries in this section are based on the information presented in this chapter.

The following query lists the process definitions present in the repository:

SELECT object_name
FROM dm_process

The following query lists the workflows for a process definition named'Loan App Approval':

SELECT w.object_name, w.supervisor_name, w.r_runtime_state
FROM dm_workflow w, dm_process p
WHERE w.process_id = p.r_object_id AND p.object_name = 'Loan App Approval'

Note that dm_workflow.r_runtime_state can have the following values:

Value

Description

0

Dormant

1

Running

2

Finished

3

Halted

4

Terminated

The following query lists the packages using a document (by its object ID), along with the workflow name and process definition ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required