Hi All,
As per my knowledge of documentum we can assign multiple workflows to single documentum object.
I want know, which workflows are assigned to single documentum object and how to get information about that workflows.
Thanks.
hi,
try executing the query
select r_object_id,r_workflow_id,r_performer_name,r_act_seqno,r_runtime_state from dmi_workitem where r_workflow_id in (select r_workflow_id from dmi_package where any r_component_name = '*********') and r_runtime_state <> 2 order by r_workflow_id,r_act_seqno,r_runtime_state
which gives the information about work-items and workflow id information,
if you could dump the workflow id's you can get all the workflow related information.
for better understanding how these objects are inter-related kindly refer content server fundamentals guide
Hi
Its possible to do that through the DA or Webtop as well
If you are using DA/Webtop v 6.5 or above [Not sure, maybe its there in 5.3 as well].
Navigate to Tools -> Workflow -> Workflow Reporting
on the new screen click on the " Edit Workflow Report".
This will give you the below screen where you can select the Document and clicking on "OK", will give you all the WF's pertaining that document:
Hope this helps. You can use DQL's to accomplish the same activity, just that it will save you some time and effort.
AS VHK suggest use that DQL if you want more details like workitem
as per your requirement you can use follwoing DQL
select * frm dm_workflow where r_object_id in (
select r_workflow_id from dmi_package where any r_component_name = '*********')
