Hi,
I have a sample project that consists in a grocery list. This grocery list is related to an Event table (monthly groceries, barbecue, office party etc.), so, when the user selects the event from a DropDown, the Backend Query has the Event ID in its filter.
This is working fine for reading, inserting and deleting items from the list, but not for updating. The database is updated correctly, but the changes are not applied to the ListView unless I navigate away and back to the page, or I select a different event at the DropDown and then the original one again.
The update operation is performed by a component that resides in another page and I tried to add a "Refresh Database Request" task in every event that touches the grocery items table, but it works only for every task except updates.
I'm using Supabase as my backend and the data comes from a view (not a table).
What am I missing or forgetting?
Thank you all,