I’m trying to set the access rules for all tables to only allow if UUID matches LinkKey, but it produces a Invalid columns error (except in the single table one):
I’ve tried 'UUID' in rec and user.LinkKey.UUID == rec.UUID or rec.get('UUID'), but the later even says unsupported syntax.
Is the only way to add the rule to all tables?
For default rules (that apply to all tables), it may be best to continue not supporting record-based conditions. Otherwise when someone adds a new table, you can end up with invalid rules (if that table doesn’t have a UUID column), and invalid rules are a situation we want to avoid.
But for the “default rules to add when adding table rules”, this error should probably be considered a bug. It would make sense to show the error if you added table rules for a table that doesn’t have a UUID column, but it’s not an error until then, and it should work fine for tables that do have such a column. I am reporting it to the engineering team to look into.