I have created a simple table in the same database as aavehicle and I created a data model for the table along with CREATE and UPDATE record actions. When I add a new record using the CREATE record action and associated UI, the data does not appear in the record List until after I run a Data Sync. When I UPDATE a record using the UPDATE record action and associated UI, the changes are reflected immediately in the record List. I have scrolled through all pages of the list and confirmed the new record does not appear. If I query the database BEFORE running the Data Sync, the new record is in the database. Any ideas why this may be happening?
Discussion posts and replies are publicly visible
Hi, An immediate sync will occur anytime Appian writes to the database table.An immediate sync will only refresh the data that was changed by Appian.
Hello! Thank you for responding! I cannot find an "immediate sync" option on the Data Sync page of my record type. I am using Appian 22.1. The only options I find under Data Sync are Sync Schedule (which allows a scheduled to be established for daily sync) and Start Sync to manually run a data sync. Can you please tell me where to find the option for enabling "Immediate sync"? Thanks!
"immediate sync" happens as soon as you update , add or delete the record.You dont need to re-sync the record. You can just refresh the record using refresh button like below snap,
There is also a functionality where you can configure refresh interval .
Though i am unsure about auto refresh after any record action.
That is what I thought. I assumed that there would be an immediate sync after I submitted the new record, but that does not happen. I have also clicked the refresh button, and the new record does not appear. The record is inserted into the database, but the immediate sync with Appian does not seem to be happening for the Create record action. The Update record action does work and changes are immediately seen in the grid.
I tried to recreate the same scenario. I created a new row using record action and once I refreshed the record list I was able to see the newly added record. I would suggest you to check your record type configuration.
Thanks. I will keep looking to see if I can figure out why this is happening. Maybe I will try creating a new record type and see if that one works properly, then compare to my first to find the differences.