dql to retrieve workflow_id from a unique process variable value

Hi,

My requirement is to attach a document as an attachment to a running workflow / existing workflow at runtime . The type of this document and the type of the package defined in the workflow is same. One of the atrribute of this type has a unique value . Now if I need to find out the worflow ID whose value for that particular attribute is same as that of the document to be attached what DQL query can i use?

If I store the value of this package attribute(variable_attribute1) in a process variable say variable1.

This value is same as the value of that unique attribute ( variable_attribute1)of the document which is to be attached to this workflow.

Can I use dmc_wfsd_element??

If I use " select workflow_id from dmc_wfsd_element where object_name='variable1' " I get multiple workflow id's.

how can I use the value of process variable 'variable1'/ 'variable_attribute1' to find the workflow id??

I need to write such a query in TBO which is triggered when a document is exported . so that this document could be attached to the respective workflow after being exported.

Thanks,

prerna

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

praks

Hi prerna,

Try this query:-

select workflow_id from dmc_wfsd_element_string where object_name='name of process variable ' and string_value='unique value of process variable' and process_id in (select r_object_id from dm_process where object_name=' workflow name' )

hope this works

All comments

muthu.vignesh

Hi,

select workflow_id from dmc_wfsd_element where object_name='variable1' and string_value='variable_attribute1'

Hope this helps.

Regards.

praks

Hi prerna,

Try this query:-

hope this works

Prerna

hi praks,

thanks for your help.

Regards,

Prerna