how to set a filter to a table based on a value that is from another table
I am developing an application using refine and supabase. I have a table called OrderProduct which is an intermediate table between two 3 tables. Client, Product and Order. The issue is that I have to make a filter based on a value of the table Order. which is the Status, and I can not do it correctly. Currently I get an error that order_product.status does not exist (Duh). But I can't figure out how to do this.
this is the IOrderProduct
id: number;
order_id: number;
product_id: number;
quantity: number;
this is the IOrderProduct
id: number;
order_id: number;
product_id: number;
quantity: number;
