Solved

Question about creating CDTs with more than 50 fields.

Forum|Forum|4 years ago
October 20, 2021
5 replies
0 views

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.

Best answer by stewart.burchell

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

stefanhelzle0001

Brainy

AFAIK, the 50 fields limit is more a best practice than a hard coded limit.

stewart.burchellAnswer

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

Y

yongsungk0001Author

Thank you. Creating a CDT with only the values I need seems great!!

peter.lewis

Employee

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

Y

yongsungk0001Author

Thank you.

Sign up

Login with SSO

Login to the community

Login with SSO