I noticed that if I use sql to update data, the data in record type need to sync manually.
I want to know is there any way that the record type can sync automatically once I update data in db. In sync options tab I only saw Schedule full syncs, but It can't suit my require.
Discussion posts and replies are publicly visible
Hi edwardc8281 Is there any particular reason you are updating the data through database using SQL instead of using Appian related actions for it. AFAIK if the data is updated through SQL script from database then a manual sync is needed to sync the data. So, every time you use the SQL to change the data, come to that particular record and sync the data.
This is by design. Do you have a specific reason to not write the data through records?
For ad-hoc updates in database like you have in your case there is no other way. Syncs can be scheduled to run at specific time only. So, the best way is to update data using records itself or sync every time to make changes in db data manually.