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
I am trying to do a foreign key filter by calling
Any thoughts?
Basically there are two tables. One is called
schedule and that is the direct table that I am querying. schedule table has a one to many relationship with schedule_details (basically there's one schedule and 7 schedule_details one for each day). I am trying to do a foreign key filter by calling
.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".Any thoughts?

