Supabase realtime filtering and ordering

[Baris]

Hi, I’m using Supabase and I couldn’t figure out how to do realtime filtering and ordering.

• If I create a collection in WeWeb, it works in realtime, but the filtering and sorting properties I define when creating the collection are applied on the client side. That’s not what I want.

• If I use a Supabase select action, I can take advantage of Supabase JS library features and filtering and ordering happen server-side. But it seems I lose the realtime feature then? Because I can’t directly bind this data to an element and have to put it into a variable.

Any help would be appreciated! Thanks.

[Broberto]

@Baris

If I create a collection in WeWeb, it works in realtime, but the filtering and sorting properties I define when creating the collection are applied on the client side. That’s not what I want.

Could you explain this part? It seems to me like all the Supabase filters used to be on the backend.

[Antiokh]

He can apply filters on a view-level when binding collection to the item collection. Maybe that’s an issue.