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

index(ri!cdt, "EmpId", {}) or ri!cdt.EmpId should do it.

This post might help: forum.appian.com/.../e-166634

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.

You are right Monika. Thanks.

To be specific please change the expression for local!columnNames to

apply(fn!extract(local!dataType, _, char(61)), {char(91) , char(44)& char(32)})

which gives all the column names including the primaryKey(Generally the first field in the CDT)

Hope it helps.