Convert a Datatype in to a Stringed List

Unknown

Convert a Datatype in to a Stringed List

Unknown

Hi,

How do I convert a datatype into a list of properties?

Thanks
[i]edited by Will@decisions.com on 3/27/2019[/i]

Unknown

Hello,

Are you looking for "Object Properties to Data Pairs" or List Mapping Step?

Unknown

Object Properties to Data Pairs < this is a awesome step! and yes exactly that!

Unknown

It looks like this only works for simple data types. Is there a way to get a List of all properties with or without values?

Unknown

You can get a list of properties and their types for any custom datatype by running:

use [DBname]
select
relationship_name as Property,
related_to_data_type as Type
from
defined_data_type_data_member
where data_structure = [namespace].[typename]
order by relationship_name asc