Hi, 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: candidate contains all the data about a candidate at the beginning of the process phoneinterviewdate contains the candidateId and the date for the phoneInterview assessment contains the candidateId and the data collected during the interview interviewer contains the candidateId and the interviewers that were assigned to conduct the interview 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 PS: 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: https://community.appian.com/discussions/f/data/20079/how-to-update-a-specific-field-in-a-cdt

How to create a record from a sql view

Karl over 3 years ago

Hi,

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:

candidate	contains all the data about a candidate at the beginning of the process
phoneinterviewdate	contains the candidateId and the date for the phoneInterview
assessment	contains the candidateId and the data collected during the interview
interviewer	contains the candidateId and the interviewers that were assigned to conduct the interview

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

PS:

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:

https://community.appian.com/discussions/f/data/20079/how-to-update-a-specific-field-in-a-cdt

Discussion posts and replies are publicly visible

Parents

0 helmuta over 3 years ago

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
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 helmuta over 3 years ago

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
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data