I want to display in a table or via repeated elements the rows of a data table from Supabase integration. In this table, rows have a parent_object_id column that refer to another row of the table.
When I check the preview, I get the right set of data:
But when I use a table, the parent_object_id just diplays wrong data (apparently randomly picked one) and I get the same results in any dynamic value query I make on the page so I cannot work with it:
Refreshing data seems to sometimes changing the id displayed for all rows, but the error is still there.
Other values on other tables seems right. Also, I have another table in the same database with a similar shema (but using integers instead of uuid for id / key) and it works fine.
What are the reproduction steps?
Add a query to a table having a parent column relationship and a table connected to this data.
@jay-dee Not sure why, but it seems that at some point you’ve had two queries that were called the same.
Your data is in the different table called query
There are three options:
I made this second query to check if the issue remained, and it did. And what’s weird is that from your account you don’t seem to have this error whereas I still have it from mine :
So I could get the display of the right data by starting again from scratch in a new page. The table displays the right data in edit mode, I thought I was okay…ish (as sometimes displayed values change randomly it seems), but actually not.
The preview mode renders the wrong data, and other queries too. In this example, I can see the parent_object_id of the selected row (bd84…) is different in the table from what I get in the query (cb57…) which matches the value I get in preview, but not the actual value.
