You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Note I am fine on creating the fts column in the table I am searching, just when I am trying to do the actual search.
Note I am trying to use this:
initial_query = initial_query.filter('fts', 'plfts', keyword_query)
Where the keyword_query is either one word or a few strung together by |
If I attempt the same query in the sql in supabase itself it works, but it doesnt work if I try and use .filter and I am not sure what else to use (eg textsearch does not exist on it).
How can I get this to work?
I have considered:
Perhaps there is a different way to format it so I get the actual results here that i have just missed
Perhaps there is a way to send the sql statement directly? (this is in python so all in the back end)
Unsure how to get this to work
Thanks in advance!
The text was updated successfully, but these errors were encountered:
Do note the single quote around 'The Aveng' as it is necessary for the full text search to work. Also in your example you have the order incorrect, its column_name, operator and criteria that the .filter function takes.
Hi!
I am wondering if there is a way to do the full text search as described here? https://supabase.com/docs/guides/database/full-text-search?language=js&example-view=sql
Note I am fine on creating the fts column in the table I am searching, just when I am trying to do the actual search.
Note I am trying to use this:
initial_query = initial_query.filter('fts', 'plfts', keyword_query)
Where the keyword_query is either one word or a few strung together by |
If I attempt the same query in the sql in supabase itself it works, but it doesnt work if I try and use .filter and I am not sure what else to use (eg textsearch does not exist on it).
How can I get this to work?
I have considered:
Unsure how to get this to work
Thanks in advance!
The text was updated successfully, but these errors were encountered: