Filtering for referenced fields in tables

Ask us anything How do I?
5

Ah ok got it!

So yeah, when you use the Advanced mode, Supabase returns an object which we indeed cannot filter on in depth at the moment. It’s a limitation of the plugin we’re aware of but not quite sure how to improve yet.

For now you have 2 solutions:

  1. create a view in Supabase where the address is a field, then fetch that view in WeWeb, and filter on that collection, or

  2. create 2 collections in WeWeb: one for your events table and one for your site table. Then, you can filter your events collection based on the id of the address in the site collection. Here’s a short video on how you would do this.

Does that help?