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
Howdy, Stranger!
Categories
- 4.2K All Categories
- 68 General
- 11 Training
- 203 Installation / Setup
- 1.1K Flows
- 108 Rules
- 262 Administration
- 212 Portal
- 494 General Q & A
- 699 Forms
- 334 Reports
- 3 Designer Extensions
- 47 Example Flows
- 53 CSS Examples
- 1 Diagram Tile
- 7 Javascript Controls
- 180 Pages
- 5 Process Mining
- New Features
- 180 Datastructures
- 69 Repository
- 221 Integrations
- 28 Multi-Tenant
- 27 SDK
- 80 Modules
- 56 Settings
- 25 Active Directory
- 12 Version 7
- 35 Version 8
- 92 Lunch And Learn Questions