DQL To Update SDT of Workflow

VishuG

Hi All,

i am using custom activity method in which i want to update the attribute of SDT of a particular workflow.

am not able to set the SDT of workflow and its not throwing any error also.

Code:

IDfWorkflow workflowObj = (IDfWorkflow)

dfSession.getObject(new DfId("4d0c0bd080004946")); IDfWorkflowEx wflowEx = (IDfWorkflowEx)workflowObj;

wflowEx.setStructuredDataTypeAttrValue(

"sdt_details", "year","8888");

am able to get SDT value using getStructuredDataTypeAttrValue but not able to set the value.

Is there any order  or  any steps to follow before setting the SDT value.

I am testing by running a standalone javaprogram by getting the workflowid.

i also tried to update SDT using DQL but not getting any results.

I  followed these steps:

1.Create SDT -- sdt_info

2.Added Process Variable -

Name :sdt_details

Type --more-types-- sdt_info (selected the SDT that i created).

Run the following DQL query to obtain the SDT id:

select r_object_id dmc_wfsd_type_info where object_name = 'sdt_info'

Am able to get Object Id of the SDT.

Make a note of the r_object_id

2. Run the following DQL query to obtain the Complex Process Variable id corresponding to your SDT:

select r_object_id, object_name from dmc_wfsd_element where workflow_id = 'Your_Workflow_Id' and sd_type_info_id = 'sdt_info'

Here am not getting any objects though i started  a process with this SDT.

Is there any DQL Query to update the SDT.

am using xCP user bundle 6.6

If any one have workaround for this please help me...

Thanks In Advance

GS