Hi Team,
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.
Thank you!
Discussion posts and replies are publicly visible
Hi Kowsalya,
If your requirement is to store a list of values into single column of the CDT row, this is not possible directly in Appian, You either have to check the field as multiple, which will create a seperate table in the backend for this field.
Or the work around can be to save all the list of values as a single semicolon or a comma seperated string.
Hi Harish,
Yes there is a backend table which got created automatically.This new table now has id of the main table,array values and their index(3 columns).
May be i can use the id as the foreign key .how can i access those records by the way.
id servicetypes index
1 break pads 0
1 Power steering fluid 1.
Please help by giving syntax.