There are total 15 tables that i need to access in the db for the record dashboa

saratrk over 9 years ago

There are total 15 tables that i need to access in the db for the record dashboard. So i have created a view in database connecting those 15 tables. Now when i created an xsd/CDT in appian and trying to save&publish in the datastore, it is throwing an error that, the view cannot be altered at db as it is a view not a table.
Can anybody let me know, how to link a CDT with database View ?

Discussion posts and replies are publicly visible

Parents

0 mahipalc over 9 years ago

The maximum number of tables that can be referenced in the definition of a view is around 60 (for MySQL).
However, if we are joining over 20 tables, that means we are stretching the system, so need to take care of performance.
Now come to the error:
* After creation of CDT/XSD import, we add an entity to data store by "Add entity".
* Then if we click "Verify", it will show all errors like (missing column name, missing column type, missing a_id etc..).
As per my understanding all these possible errors can be thrown at "Verify" action itself, not at "Save & Publish" action.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 mahipalc over 9 years ago

The maximum number of tables that can be referenced in the definition of a view is around 60 (for MySQL).
However, if we are joining over 20 tables, that means we are stretching the system, so need to take care of performance.
Now come to the error:
* After creation of CDT/XSD import, we add an entity to data store by "Add entity".
* Then if we click "Verify", it will show all errors like (missing column name, missing column type, missing a_id etc..).
As per my understanding all these possible errors can be thrown at "Verify" action itself, not at "Save & Publish" action.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data