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.
Hi marcoc0005 could you perform a full sync and check in the record
Being a record based on a view we don’t even sync option, it is not possibile ti create synched record on a view
We don’t have sync option being a record based 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?
Hi marcoc0005 Could you refresh the view once , and from Appian side could you disconnect the table and connect again into record type and check
Then, I think this is a problem outside of Appian.
I have deleted and reacreted the view with the same query and discconnected and recconected the table and now it works. The problem is that in test environment I can do it, in production no. Do you know why this wrong behaviorur from Appian?