I have created an app that has multiple CDTs and created a MySQL View in the Appian Database. I would like to use this view as source for my record.
I am building a recruiting application. After each user task in the process model I write the data to a different CDT. The CDTs have foreign keys so that I can link the different tables via SQL:
When I try to build my record I am prompted to secify the datastore, but naturally the data store only references the connections between database-table and CDT.
How do I connect to the view that I have created in the Appian MySQL database?
Thanks in advance. Best regards Karl
I only decided to use multiple CDTs because I didn't know how to update a specific CDT-row from within a process and used the CDTs above to build a work-around. I need to solve either problem to get the app running:
Discussion posts and replies are publicly visible
If I am understanding your problem here are some steps to creating the record. Create a CDT for your view and make it part of the data store. Reference your view CDT using a constant. Here is some information about creating a view for a record. https://docs.appian.com/suite/help/20.4/Create_a_Record_View.html
© 2021 Appian. All rights reserved.