Follow by Email

Wednesday, June 11, 2014

Documentum getting list of workflow performers

Below queries can be used to get the details about

  • What happend during a wrokflow
  • Which user performed which task
  • How long a task was waiting to be processed e.t.c.

  1. Use the below query to get the process ids related to your templete
            select * from dm_process where object_name like '%DBP%';
2. Use the Below query to get  the completed workflow ids related to a process id

select * from dmc_completed_workflow where process_id = 'my_process_id';

 3. Use the below query to get the information related to a completed workflow

select * from dmc_completed_workitem where workflow_id in (select workflow_id from dmc_completed_workflow where process_id = 'my_process_id' )

order by workflow_id, act_seqno;

No comments:

Post a Comment