Does anyone know how to do a WHERE NOT IN query?
# off-topicc
carlomigueldy.eth
08/02/2021, 12:14 AMDoes anyone know how to do a WHERE NOT IN query?
s
Scott P
08/02/2021, 12:17 AMHow are you currently running
WHERE INc
carlomigueldy.eth
08/02/2021, 12:18 AMI use Flutter,
supabase.from(table).select().in('column', arrayValues).execute();
carlomigueldy.eth
08/02/2021, 12:18 AMAnd I don't see a NOT IN from docs
s
Scott P
08/02/2021, 12:21 AMif you do
supabase.from(table).select().not().in('column', arrayValues).execute();c
carlomigueldy.eth
08/02/2021, 12:23 AMLet me try!
carlomigueldy.eth
08/02/2021, 12:24 AMLooks like it won't
carlomigueldy.eth
08/02/2021, 12:24 AMI tried the other day,
not('column', 'in', ['value', 'valuedsd'])
Does not work, it just throws an unexpected [ ] charcater instead
s
Scott P
08/02/2021, 12:35 AMThat's very strange.
I'm working in JS so this might not be the same, but this example shows that
in Copy code
dart
supabase
.from("table")
.select()
.not("column", "", [])
.execute()c
carlomigueldy.eth
08/02/2021, 12:39 AMYeah it's pretty weird.
This is the exception I am getting
Copy code
"failed to parse filter (not.in.[])" (line 1, column 8)carlomigueldy.eth
08/03/2021, 12:12 AMHi @User . It dosen't work in Flutter or my query syntax is wrong?
h
hieu
08/03/2021, 7:49 AMcan you create an issue on https://github.com/supabase/postgrest-dart
thanks
c
carlomigueldy.eth
08/03/2021, 7:49 AMOk will do
h
hieu
08/03/2021, 7:50 AMi guess we didn't support list value properly for not()
c
carlomigueldy.eth
08/03/2021, 7:50 AMI see, thought it wasn't a bug
h
hieu
08/03/2021, 7:52 AMc
carlomigueldy.eth
08/03/2021, 7:54 AMI SEE.
h
hieu
08/03/2021, 7:54 AMi think it's a bug from postgrest-dart
c
carlomigueldy.eth
08/03/2021, 7:54 AMNow it makes sense
carlomigueldy.eth
08/03/2021, 7:54 AMSo basically I have to make it a string
(uuid, uuid, uuid)
h
hieu
08/03/2021, 7:55 AMhahah, yeah in the mean time can you try to escape your list properly before passing to not()
hieu
08/03/2021, 7:55 AMString _cleanFilterArray(List filter) {
return filter.map((s) => '"$s"').join(',');
}
c
carlomigueldy.eth
08/03/2021, 7:55 AMThanks man, regarding the ticket here it is https://github.com/supabase/postgrest-dart/issues/36
If team decides to add a support for List
Otherwise I think it would be good to involve into the README as example of using where not in
carlomigueldy.eth
08/03/2021, 7:55 AMPerfect, thanks man!