Supabase realtime filtering and ordering

Ask us anything How do I?
1

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.

2

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

3

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