Hi Everyone,
I have created an interface which have grid rows. The fileds are populated from two tables, so I have created a view for that. What I need to implement that if a record is entered into one table, the corresponding fields from other table needs to be updated. Can anyone please suggest any solution for this?
Thank You
Discussion posts and replies are publicly visible
I am not 100% sure if I understand your issue correctly.you have already your view and you can display this view via datastore-cdt-queryRule-interface-table logic.So if you update one table (as part of the DB SQL view) , your view CDT content is automatically updated as well.Thats the main idea of DB views. Can you elaborate your question?
Yes, that is correct. So the main concept is the view includes two DB tables. And my query is if one DB table is updated then the related second tables should be updated to some default values.
This will have to occur where your record is entered into table 1, or via a trigger on the DB table (although preference is always to achieve within Appian when possible). How is your record entered?
Hi Chris, Correct I would like to acheive it through appian instead of DB trigger. Record is entered into one table using excel upload.