I am trying to do a fairly simple Backend query on a supabase table - The issues Im having are
1 - it only seems to allow 1 filter (if you add filter 2 this seems to be ignored (I can search on firstname or surname, but only in query1 - if i say query 1 find surname, query 2 find firstname, query 2 is ignored
2 - the query is case sensitive
3 how do you use 'Or' statements
5 if there is a hyphen in the data (like hyphenated surnames) the data isnt returned
Am i missing something here, can i write the sql query and add in the page variables in another way, as this seems to be unusable ?