Skip to main content
A
anuradhac0001
September 29, 2022
Question

CDT with array field saved as 2 tables in DB

  • September 29, 2022
  • 10 replies
  • 0 views

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?

    10 replies

    harshitb6843
    harshitb6843
    September 29, 2022

    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. 

    A
    anuradhac0001Author
    September 29, 2022

    Harshit, do i need to create a recordtype for the appian generated table first?

    harshitb6843
    harshitb6843
    September 29, 2022

    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. 

    Terms & ConditionsAccessibility statement