I have been trying very hard to get Flutterflow work with SQLite but it's getting very difficult. I have a list of items and it loads ok using the "Backend query" feature. But to add another item to the list I use 2 bottom sheets one after the other and the addition works fine too but I want to show the new item in the list on the original page after the bottom sheets gets dismissed but this is not working.
I have tried 2 methods to do it.
I added the item in list and tried calling the "Refresh Database Request" for the list view component but the problem with this method is that "Refresh Database Request" functionality doesn't work with SQLite queries for some reason. There is no option to select the SQLite powered widgets.
To resolve this issue I tried to make a page state variable with the a predefined data type. The list view instead of iterating over the Backend Query will now iterate over this variable. This way I would be able to change the value of this variable from backend calls and on "Actions". To initially load data into this variable I'm making a backend call on initialisation of page to get data and initialise the variable using the "Update Page State" action. But I'm not able to map this one list over the backend result. In short, I am unable to initialise my variable with the result of the "Backend Query".
