How can I do conditional filter chaining. I am cu...
# help
c
How can I do conditional filter chaining. I am currently using this but it is not good if I want to add more filter options as a form in my app:
Copy code
js
let searchTerm

if (searchTerm) {
  const {data, error} = supabase.from('products').select('*').ilike('name', '%' + searchTerm +'%')
} else {
  const {data, error} = supabase.from('products').select('*')
}
g
Not sure if Scott intended to answer, but you can build up your queries and then execute: https://supabase.com/docs/reference/javascript/using-filters#conditional-chaining
c
Thanks