Thursday, March 3, 2011

DQL to get workflow of document

Given the document name XXX018.doc

SELECT r_object_id FROM dm_document WHERE object_name = 'XXX018.doc'
or
SELECT r_object_id FROM dm_document WHERE object_name LIKE 'XXX018%'

select * from dm_workflow
where r_object_id in (select r_workflow_id
from dmi_package
where any r_component_id in (select r_object_id
from dm_sysobject (all)
where i_chronicle_id in (select i_chronicle_id
from dm_sysobject where r_object_id='09000578802335ad'))) and r_runtime_state='1'

No comments:

Related Posts Plugin for WordPress, Blogger...