get workflow using dql

How can I get work flows that are attached to a particular document where I have r_object_id.

please help me.

thanks in advance.

Find more posts tagged with

Note:

If there are Accepted Answers, those will be shown by default. You can switch to 'All Replies' by selecting the tab below.

Accepted answers

SELECT * FROM dm_workflow WHERE r_object_id IN(SELECT r_workflow_id FROM dmi_package WHERE ANY r_component_id =ID('09....'))

All comments

SELECT * FROM dm_workflow WHERE r_object_id IN(SELECT r_workflow_id FROM dmi_package WHERE ANY r_component_id =ID('09....'))

I'm guessing the first one was right, but the way we have our workflow, documents are attached as elements in the dmi_wf_attachment table, so the query for this setup would be:

select * from dm_workflow where r_object_id in (select r_workflow_id from dmi_wf_attachment where r_component_id = 'YOUR_OBJECT_ID' )