# Filtering for referenced fields in tables

**URL:** https://community.weweb.io/t/filtering-for-referenced-fields-in-tables/3397
**Category:** How do I?
**Created:** [July 6, 2023, 1:02am UTC](https://community.weweb.io/t/filtering-for-referenced-fields-in-tables/3397 "2023-07-06T01:02:31Z")
**Posts on this page:** 1
**Showing post:** 5

<div class="post-metadata">

### Author: ![Joyce](https://sea2.discourse-cdn.com/flex016/user_avatar/community.weweb.io/joyce/32/13232_2.png) [@Joyce](https://community.weweb.io/u/Joyce)
#### Post date: [July 6, 2023, 4:36pm UTC](https://community.weweb.io/t/filtering-for-referenced-fields-in-tables/3397/5 "2023-07-06T16:36:40Z")

</div>

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](https://tella.video/supabase-filtering-ref-fields-c5kv) on how you would do this.

Does that help?

---

_[View the full topic](https://community.weweb.io/t/filtering-for-referenced-fields-in-tables/3397)._