Wednesday, March 2, 2011

DQL to find details based on workflow item

Based on this information, get the workflow details and document.
Started workitem: "4a000578800d9915" in docbase "ecmdocbase"

1. Get workflow id from package id
select r_workflow_id from dmi_workitem where r_object_id = '4a000578800d9915'

2. Get workflow details
select * from dm_workflow where r_object_id = '4d0005788004d500'

3. Get the document id from workflow package
select r_component_id from dmi_package where r_workflow_id = '4d0005788004d500'

4. get the document name
select * from dm_document where r_object_id = '0900057880210948'

1 comment:

Kani Mozhi said...

I looked on the internet for the difficulty and found most individuals will associate with along with your website. Keep update more excellent posts.
Document Management Software
Document Management System
Electronic Document Management Software
Best Document Management Software

Related Posts Plugin for WordPress, Blogger...