n
02/14/2022, 4:26 PMHhorn
02/14/2022, 6:18 PMsupabase.client .from('$tableName:id=eq.$documentId')
.
According to the walrus github other operators like gt. would be supported. But I always get an Unhandled Exception: relation "..." does not exist. Would be really nice if anyone could help ๐swiss
02/14/2022, 7:14 PMgaryaustin
02/14/2022, 7:33 PMFlyken
02/14/2022, 9:36 PMhttps://i.imgur.com/yZPxBa5.pngโพ
Hadi
02/14/2022, 10:23 PMMichie
02/15/2022, 12:22 AMvanderrlay
02/15/2022, 12:47 AMRutik
02/15/2022, 1:06 PMError 400: redirect_uri_mismatch
edited with solution: in google cloud console add the url with
/auth/v1/callback and it will be fixedmalaleche
02/15/2022, 2:33 PMmalaleche
02/15/2022, 2:42 PMmalaleche
02/15/2022, 3:31 PMmalaleche
02/15/2022, 3:31 PMKillewolf
02/15/2022, 3:42 PMcarlosloureda
02/15/2022, 3:43 PMTremalJack
02/15/2022, 4:43 PMAmusedGrape
02/15/2022, 5:11 PMTremalJack
02/15/2022, 5:18 PMAmusedGrape
02/15/2022, 5:18 PMTremalJack
02/15/2022, 5:18 PMTremalJack
02/15/2022, 5:19 PMcbecde
02/15/2022, 5:56 PMGlockstrap
02/15/2022, 6:03 PMjs
let { data: requests, error } = await supabase.from('requests')
.select(`
*,
status!requests_status_id_fkey (*)
`)
.order('created_at', { ascending: false })
.neq('status.name', 'Archived')
.eq('user_id', user_id)
So I'm using this query against the API currently. However, this is still returning requests which are 'archived'. I even tried doing status.id and doing .neq(status.id, #)
and that still returned records with 'Archived'. Am I doing something wrong? I cant find anywhere in the documentation where to filter on relationships, it just appears not to work.Glockstrap
02/15/2022, 6:10 PMgaryaustin
02/15/2022, 6:17 PMGlockstrap
02/15/2022, 6:21 PMrequests
have a status_id
. status table has 4 statuses, each with a unique name, one of them being Archived. There are others like 'Picked Up', 'Completed'. But this filter doesn't seem to do any filtering on requests itself, it instead filters the returned joined status.Glockstrap
02/15/2022, 6:21 PMGlockstrap
02/15/2022, 6:27 PMThomas van Broekhoven
02/15/2022, 8:06 PMGetPublicUrl()
method.
What happens:
1. I uploaded an image to a bucket.
2. I displayed the image using getPublicUrl(), the correct image showed up.
3. I uploaded a new image (with upsert: true) with the same name, Succesful.
4. I tried to display the new image with getPublicUrl(), but it keeps returning the old image..
The image is updated when I check app.supabase.io, but when I request the public url from there, it gives me a supabase.in url instead of supabase.co.
I tried several thing including cache control, but can't figure out why my app keeps displaying the old image. Anyone recognises this or knows what I am doing wrong? Thanks a lot!
PS: I see a similar case was reported in this channel 3 hours ago by @Usersimongreenuk
02/15/2022, 9:03 PMfetch
hook to retrieve data (my app is using SSR) and when I first navigate to a page I call this.$supabase.auth.user()
from fetch
and get the user info back but if I refresh the browser null
is then returned, which is causing me a real headache... I can see the user info still in localStorage but I'm not sure why the call to get the user info fails after a reload?