Convert a Datatype in to a Stringed List
Convert a Datatype in to a Stringed List
Comments
-
Hi,
How do I convert a datatype into a list of properties?
Thanks
[i]edited by Will@decisions.com on 3/27/2019[/i] -
Hello,
Are you looking for "Object Properties to Data Pairs" or List Mapping Step?
-
Object Properties to Data Pairs < this is a awesome step! and yes exactly that!
-
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?
-
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