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
The last column shouldn't be a primary key. You cannot have more than one of such keys. Drop the primary key constraint from the last column.
It is an auto generated table with a combination of two fields as primary key. It uses index to refer back to the Variations table. So cannot make changes to that. Not able to generate a recordtype too. If i could generate a recordtype then it is easy to fetch related data.
The first column should be the Primary key. The last column should be a foreign key.
That table is generated automatically. Primary key, index key etc it has been set automatically. Should i change it? If so how?
Download the CDT via XSD and edit it. That should give to access to these properties. Or you can directly update that via alter commands on the DB itself and Verify the mapping again in the DS