Hi all, we have a record based on a view in an oracle database.
Some day ago we delete some data from the tables from which the view get the data and now the view has 253 rows, but if I open the record list we found 11583 rows. How is it possibile? With this scenario the record should execute the query every time we open it
Discussion posts and replies are publicly visible
If the record in synced , you will have to make a full sync until the data you view is refreshed.
Go to sync history in your record, and click on start Full Sync. After that, the data should be updated.
Being a record based on a view we don’t even sync option, it is not possibile ti create synched record on a view
Could be possible that is using a materialized view? A MV works as a table
community.appian.com/.../use-database-and-materialized-views-in-appian
No unfortunately no
Could you give more details? How it's implemented? do you see any error in tomcat-stdout.log?