Hi everyone!
I have a transactions table with id, value and status. I'm using the On Page Load action with Supabase Query Row. I need to use On Page Load because I have other queries to execute.
I have the Listview component that is rendering the values through the Generating Children Variable and loading all the transactions from the Action Output results. I'm trying to filter the status, so it's quite simple, I want to load all the results and then filter by status. To achieve this, I created a bottom sheet with all the available statuses and I'm passing the status value to a local page state using the component parameter and then applying this value to the Generating Children Variable.
Because of this, it loads empty, but if I apply the filter it works, for example if I select paid status in the bottom sheet it brings the return correctly. The problem is that since I'm applying the filter by status there is no status for all the items. How to ignore empty results and show all items? I know it is possible using backend query but I do not know how to achieve this using query row in action page load.
Thanks!