I have a question regarding querying using a filter for multiple nested tables using Custom API.
I have 3 tables.
material with fields = id, name, material_brand (relation to material_brand table)
material_brand with fields = id, brand_name, material_type (relation to material_type table)
material_type with fields = id, type_name
So far I have managed to query the material table that filters material_brand (GET /material?select=*&material_brand=eq.[id]
But what I am trying to do is to query and filter based on material_type. How can I achieve this?
Appreciate all the help, thank you.