Hi All, Is there any way to retrieve the fields of CDT and store in a varia

Amit Mishra over 8 years ago

Hi All,
Is there any way to retrieve the fields of CDT and store in a variable (multiple type)? Scenario: I have to fetch all the fields of CDT (like- EmpId, EmpName, DOJ etc.) and showed them in a drop down options of a form interface.

Discussion posts and replies are publicly visible

Parents

0 monikar over 8 years ago

Hi Amit

If I'm not wrong you want to get the field names of a custom data type irrespective of the CDT type. If yes, I'm not aware of any existing Appian function which provides such functionality but the generic expression given below will be helpful to get all the column names in the CDT.

load(
local!dataType: tostring(cast(typeof(ri!data), {} )),
local!columnNames: extract(local!dataType, char(44)& char(32), char(61)),
columnNames
)

Here ri!data can be of anyType to make the expression as generic.

Please let me know if I got you wrong.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 monikar over 8 years ago

Hi Amit

If I'm not wrong you want to get the field names of a custom data type irrespective of the CDT type. If yes, I'm not aware of any existing Appian function which provides such functionality but the generic expression given below will be helpful to get all the column names in the CDT.

load(
local!dataType: tostring(cast(typeof(ri!data), {} )),
local!columnNames: extract(local!dataType, char(44)& char(32), char(61)),
columnNames
)

Here ri!data can be of anyType to make the expression as generic.

Please let me know if I got you wrong.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data