i have designed a CDT for Vehicle Maintenance where one of the column is for what are all the last performed services as per vehicle maintenance schedule.
latestScheduledServiceTypes Text 255 Checked the Array checkbox .
So i do expect the column to store the list of values as it is an array?
Can a column in database be used to hold array of values? because in cloud db when i checked no value is getting saved in this column.
Even on the interface, i just displayed the value for this, i dont see any value for that column its just null.
Please help me with the significance of Array checbox in CDT's? and also how to store them into Cloud database.
Discussion posts and replies are publicly visible
latestScheduledServiceTypes is a nested CDT, and is a list of values. Nested CDTs can't be stored in a single column in the table. You need to define another table to store these values and define the foreign key relationship to the parent CDT. Please refer this page for more info. https://docs.appian.com/suite/help/19.2/cdt_design_guidance.html#writing-to-data-store
© 2022 Appian. All rights reserved.