Supabase•4y ago•

14 replies

I can't figure out how to get filtering through foreign tables to work

This is in Rust so it looks a little different but it functions exactly like the JavaScript SDK.

Basically there are two tables. One is called

schedule

schedule

and that is the direct table that I am querying.

schedule

schedule

table has a one to many relationship with

schedule_details

schedule_details

(basically there's one

schedule

schedule

and 7

schedule_details

schedule_details

one for each day).

I am trying to do a foreign key filter by calling

.eq("schedule_details.purchase_day", day)

.eq("schedule_details.purchase_day", day)

with day = whatever day it is. Supabase is returning the following error

"column schedule.schedule_details.purchase_day does not exist"

"column schedule.schedule_details.purchase_day does not exist"

.

Any thoughts?