I have a single Action column on a data grid and I am firing off a simple supabase update in that workflow which WW says it has completed successfully but the supabase DB update for the row has not executed?..
(note: The update button is for a form above, not for the data grid. To trigger the datagrid Confirm action I simply click the “Confirm user” link on the row.)
The Confirm User Supabase runs successfully, but it hasn’t updated the DB…
There was actually some AI code in the UPDATE RLS that was not needed and I thought that was what the problem was… However, when I set the UPDATE RLS to the most simple “authenticated users” only and I fire off the simple supabase update for the record from my authenticated WW session… it STILL does not update the record… … (WW should not be telling me that something worked when it hasn’t.)
So I am still at square 1 … Simple Supabase update does not work…
Ah… it’s working now! I had some code running on the select policy for the “profiles” table supabase was trying to update that seems to be affecting the update (although I couldn’t see why). I had to add some data for the currently logged in user into a seperate table so that ithe logged in user was included in that select policy. (But from what I could make out, it still should not have affected the UPDATE attempt in supabase. The RLS policies can get a bit complicated when you have semi-complicated user secrurity as I have.