Filtering results by foreign key via cURL request
Hello, I've just recently started with Supabase and RESTapi request and I've came across the issue where my results cannot be filtered by foreign key value. When I filter them with the same table column, everything works perfectly. However, once I try to filter it with a foreign key, it returns my filtered query in addition to unwanted data with NULL field instead of previous value.
My example look like this:
Table 1 - Orders
SKU(same value as table 2)
owner_foreign_key(FK)
Table 2 - Vehicles
SKU (same value as table 1)
owner_name [array]
example.supabase.co/rest/v1/orders?owner_foreign_key.owner_name=eq.{owner_name}&select=SKU,owner_foreign_key(owner_name)
Maybe someone could point me to the right direction or assist me into filtering further to ignore the NULL values and only return the queried owner_name value. Thank you!
My example look like this:
Table 1 - Orders
SKU(same value as table 2)
owner_foreign_key(FK)
Table 2 - Vehicles
SKU (same value as table 1)
owner_name [array]
example.supabase.co/rest/v1/orders?owner_foreign_key.owner_name=eq.{owner_name}&select=SKU,owner_foreign_key(owner_name)
Maybe someone could point me to the right direction or assist me into filtering further to ignore the NULL values and only return the queried owner_name value. Thank you!
