Please tell me I'm missing something simple... For the life of me I can't get a table to populate with a basic query. It works fine when creating / editing the app, but as soon as I hit the play button to view the app in action... the table is empty, even though the SQL is valid and works fine when run directly in the database.
Goal: Show data in a table. I expect data to show in the table
Steps: I've set a variable to watch the SQL query, confirmed it returns 100 rows when run in Supabase UI, confirmed it returns 100 rows when editing / testing the app.
Hello there! Welcome to the forum!
I'd like to point out that this is not the best way to consult a database. You should create a resource query to perform this operation.
Nevertheless, let's try to pinpoint the issue: Have you published your changes to the app by creating a new release? If not, please do, as the changes shown in the editor may not be live yet in the App (as the editor, you'll always see the latest changes, but as a user, you'll only see the latest published changes.
Hope this helps! Let me know if you have further questions.
Hi @what_a_retool Did this turn out to be an issue where you needed to publish a new release?
Another note is that Javascript queries only trigger manually. If you need to trigger ActivitySelectQuery in order to see the table data, you'll need to create an event handler for that or set ActivitySelectQuery to run on page load (in the Advanced tab):
