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

Sign In or Register to comment.