which type to query for Structured Data Types

Prerna

Hi,

When a workflow template has process variables of the type ‘String’ we query the type :  dmc_wfsd_element_string to find the variable value in DQL, however when we have variables of a particular Structured data type which type do we have to query?

Regards,

Prerna

Abhi_Indulkar

Run below query to find out the available types in your repository:

select * from dmc_wfsd_type_info;

You will be able to see your SDT type name. Find out the "element_type_name" attribute value of your SDT object from the dump of the SDT object returned by above query. Using element_type_name attribute value you can find the required SDT attribute values.

For Example: if your SDT element_type_name value is dmc_wfsd_sdt_test

Query will be something like:

select * from dmc_wfsd_sdt_test where workflow_id = '*****'

This query will not work in SAMSON. Use DA or any other utility.