Question about creating CDTs with more than 50 fields.

Question

Hello, 
 
 Now, I am making an application with an existing Oracle DB. However, in the existing DB, the number of columns in the two tables is 64 and 69, which is more than 50. (I know that if the number of fields (columns) exceeds 50, CDT is not created, and it was not actually published in the Data Store.) 
 If it is for the purpose of inquiry, creating a view table would be good enough. But to insert , you have to insert into an existing table rather than a view. If you cannot change the existing DB, how should you configure it? 
 
 Thank you.

Stewart Burchell · Accepted Answer

the 50 attribute "limit" is a recommendation rather than a hard limit 
 you an create "partial" CDTs - that is, if you only need to update 10 values in a table that has 69 columns you can create a CDT that maps just to those 10 values

Peter Lewis · Answer

The other posts are correct - and also our official guidance just recommends less than 100 fields. See the design guidance page for more information: docs.appian.com/.../appian-recommendations.html

Question about creating CDTs with more than 50 fields.

Top Replies