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 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?
Screenshot_2022-11-17_at_5.49.46_PM.png
Screenshot_2022-11-17_at_5.54.38_PM.png
Was this page helpful?