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 Conor Cahill
Certified Lead Developer
over 9 years ago

You'll want to make sure there's a unique column in your view that you can call your "key". Then in the XSD give that column the @id and @generatedValue attributes. Make sure all your columns match the CDT fields. Then your data store should publish.

Does the ddl script tell you what it is trying to alter in the view?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Conor Cahill
Certified Lead Developer
over 9 years ago

You'll want to make sure there's a unique column in your view that you can call your "key". Then in the XSD give that column the @id and @generatedValue attributes. Make sure all your columns match the CDT fields. Then your data store should publish.

Does the ddl script tell you what it is trying to alter in the view?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data