Workflow attributes

athiq.rahaman

Hi I need a query to display workflow attachment attributes. that is for workflows we have attachments and for those attachments we have attributes, i need to display those attribute values in datagrid in a form.

any one help me with this query..............

mszurap

If the "attachments" are packages, then this query should do if you know your workflow's id:

SELECT your_attributes FROM your_type WHERE r_object_id IN (select r_component_id from dmi_package where r_workflow_id='your_workflow_id')

Note, that this will return any document which was involved in the workflow. If you need only those which were added in a specific step (for example at start), then you need to add "and r_act_seqno=your_step_number" in the nested query.

Mike