Supabase API query with filter in multiple nested table

I have a question regarding querying using a filter for multiple nested tables using Custom API.

I have 3 tables.

  1. material with fields = id, name, material_brand (relation to material_brand table)

  2. material_brand with fields = id, brand_name, material_type (relation to material_type table)

  3. 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.

3
9 replies