Question

Record on a view cached data

Forum|Forum|2 years ago
April 10, 2024
13 replies
0 views

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

Brainy

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.

marcoc0005Author

Being a record based on a view we don’t even sync option, it is not possibile ti create synched record on a view

Brainy

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

karumurua531442

Hi [mention:61ffdccaf45e4823b1ec7d1dcf8234e5:e9ed411860ed4f2ba0265705b8793d05] could you perform a full sync and check in the record

marcoc0005Author

We don’t have sync option being a record based on a view

stefanhelzle0001

Brainy

Then, I think this is a problem outside of Appian.