I have an app which gets the items in a gallery in the onVisible property of the screen using a SQL View stored in a collection. However when i make changes to items and write them back to the underlying table (using collect) if I go back a screen then return to the same screen the change has not updated in the view of the table. I'm using the view of the table for performance reasons as the table has more than 1.2 million items, but I need the most upto date data at all times.
I can see the same thing if I delete an item from the underlying table, it doesn't reflect in the view immediately when I reload the screen. Is there any way to resolve this?