Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
6 replies
Subscribers
10 subscribers
Views
2410 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Data and Records
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 ?
OriginalPostID-149526
OriginalPostID-149526
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