I’d like to select the records for a specific UID from a Supabase table. I’ve configured the Select statement to return the correct records (red arrow) but I don’t know how to access either the returned array or the count (green box).
Thanks!
Hi. Thanks for the quick response.
I probably should have mentioned a complicating factor. Namely, I have RLS set up to only return the records where the UID of the logged in user = the UID in the Supabase table. For the user in the above image, there are only 3 records that meet this criteria.
I’m trying to build an Adminisrator’s dashboard. I’ve set up an Administrator RLS policy to see all records for any UID. In the above example, the Administrator (who has 3 records) has issued a Select for another UID (which has 40 records). The Select has returned the proper number of records BUT, when I access the collections data, it only shows the 3 records (which is correct because I’ve configured the filter to mimic the RLS policy).
So, what I want to do is get the result of the Select … the 40 records that are shown in the image. Is there a way to do that?
Thanks so much for your help!
to access the data returned by the select action you simply select the return value of the action
it’s easier if you give a name to the action or you only read “from action N” as a label. the result appears undefined until you test the action
Wow! THANKS! That worked great!!!
Really appreciate the help!
Best regards,
Steve
1 Like