How to use .or() filter with joined table columns in Supabase?
Hey everyone! I'm trying to search across both a main table column and a joined table column using .or(), but I keep getting a parse error.
What I'm trying to do:
Search for jobs by either job title OR company name (from joined table)
My code:
typescriptlet query = supabase.from("jobs").select(
// This fails with parse error
query = query.or(
"failed to parse logic tree ((title.ilike.%air%,companies.name.ilike.%air%))"
What I've tried:
Using company.name (the alias) - doesn't work
Using companies.name (the table name) - doesn't work
Using just .ilike() twice creates an AND condition, not OR
Question:
Is it possible to use .or() to filter on joined table columns? If not, what's the recommended approach for "search by title OR company name" functionality?
Thanks in advance!
What I'm trying to do:
Search for jobs by either job title OR company name (from joined table)
My code:
typescriptlet query = supabase.from("jobs").select(
*,
company:companies!inner(id, name)
, { count: "exact" });// This fails with parse error
query = query.or(
title.ilike.%${searchTerm}%,companies.name.ilike.%${searchTerm}%);"failed to parse logic tree ((title.ilike.%air%,companies.name.ilike.%air%))"
What I've tried:
Using company.name (the alias) - doesn't work
Using companies.name (the table name) - doesn't work
Using just .ilike() twice creates an AND condition, not OR
Question:
Is it possible to use .or() to filter on joined table columns? If not, what's the recommended approach for "search by title OR company name" functionality?
Thanks in advance!
