I have a CDT "Variation" that has a field "size" with multiple text values(array field). This is saved in the DB as 2 seperate tables, namely, Variation and one appian generated table.
Now i am not able to see the field "size" in the recordtype of Variation. any idea how to get the "size" field in the recordtype object?
Discussion posts and replies are publicly visible
As this is a one to many relationship where one variation is associated with multiple size, so you should have the variation primary key in the size table (auto generated by Appian). You can use the record relationships here to link the two records and get the data from the related record.
Harshit, do i need to create a recordtype for the appian generated table first?
Yes. Or else, you will have to use two query entities. First one to query the data from Variation table and then take the variation Id, pass that as a filter in the size table and query data from that table.
not able to create a recordtype