Has anyone noticed that when you use Supabase in WeWeb Unify, and create table views of your data, the filtering logic is off. I am consistently getting all rows or no rows and I specifically have the “Ignore if empty” toggle off.
I have two parameters (scope and scopeID) and I am creating conditional groups around them. The scope can be rep/nurse/all/none, whereas the scopeID is the ID of the specific rep/nurse.
The filter is simple:
- If scope is all, show all rows,
- If scope is none, show nothing.
- If scope is rep, show only the rows where rep_id = scopeID
- If scope is nurse, show only the rows where pnp_id = scopeID
I have it set up in groups to achieve this:
But it seems that irrespective of the conditions of the groups, they tend to allow the filters to still return all rows. This is also true for very simple filters:
If you have an ID and want to show only the record with that ID, You must define the filter for that ID, but you MUST also define the condition explicitly that if that ID is empty, the view must return an ID that you know is not in the db (I use “aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa”), otherwise the filter will always return all values. This work-around is however not working for the case I explained above.
I’d appreciate some help/tips if anyone has experienced this and has found a way around it. Thanks!