WeWeb Unify: Table View filters of Supabase Tables are off

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!

It might be doing this because you’re using “or” between each conditional group instead of “and”

@Janus I also have this problem, specially when I need “is empty” or “is not empty” and I already tried changing AND/OR and nothing.

This is my filter:

If alcance is empty (no filter selected) → don’t apply any scope filtering (show everything)

  • If alcance = "centro" → only show banners where centro_id is not empty (banners assigned to a specific center)
  • If alcance = "corporativo" → only show banners where centro_id is empty (corporate/fallback banners with no specific center)

  • If I change it to AND → it shows nothing, doesn’t matter the value of “alcance”, even if “alcance” is empty (which means it should not apply the filter…)
  • If I leave it to OR → it shows everything, doesn’t matter the value of “alcance”

@Tracy what would happen if you removed that outer conditional group and then simply changed it to “and”?

No results, doesn’t matter the value of “alcance”

Hey @Janus @TracyY @Msanders4
Just a quick note to let you know we are looking into it. We’ll share an update asap, most likely later this week or next.

Hello everybody! Should be fixed now.