Appian Community and Appian Academy are being upgraded. From July 24–August 3, the Appian Community will be in read-only mode. During this time, the site will be read-only and user registration will be disabled. We apologize for any inconvenience this may cause, but a more secure, stable, and performant Community experience is coming soon!
The new Appian Community launches August 3, followed by Appian Academy on August 7. During the migration, Appian Community Edition, Appian Academy, Documentation, Certifications, Instructor-led Customer Training, Partner Sales Training & Accreditation, and Forum (for Appian Partners and Customers only) will remain available.
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.