Hey feeling like I'm blind here. With the followin...
# help
b
Hey feeling like I'm blind here. With the following query `data === []`:
Copy code
console.log('getOneJobFromDb', jobAddress)
let { data, error } = await supabase
    .from('jobs')
    .select('*')
    .ilike('address', jobAddress) // using ilike to manage case-insensitive search
if (error) {console.log('eerrrororor', error)}
console.log('DATA',data)
I expect to receive ONE hit. Because when I copy paste the value of
jobAddress
into the filter in the table exploration of app.supabase.com, it yields the expected result:
n
Hello @Big Bird! This thread has been automatically created from your message in #843999948717555735 a few seconds ago. We have already mentioned the @User so that they can see your message and help you as soon as possible! Want to unsubscribe from this thread? Right-click the thread in Discord (or use the ``...`` menu) and select "Leave Thread" to unsubscribe from future updates. Want to change the title? Use the ``/title`` command! We have solved your problem? Click the button below to archive it.
g
Do you have RLS on? Not meeting that returns []
b
That was it! Thank you
n
Thread was archived by @Big Bird. Anyone can send a message to unarchive it.