Steve
10/22/2021, 6:59 PMMaximous Black
10/24/2021, 6:55 AMts
let { data: Users, error } = query.search
? await supabase
.from('User')
.select('*')
.ilike('username', `%${query.search}%`)
: await supabase
.from('User')
.select('*')
like any ILIKE
query that matches all values?Maximous Black
10/24/2021, 7:04 AMts
let { data: Users, error } = await supabase
.from('User')
.select('*')
.ilike('username', `%${query.search || ""}%`)
kresimirgalic
10/24/2021, 6:06 PMgaryaustin
10/24/2021, 6:54 PMkresimirgalic
10/24/2021, 6:55 PMminna
10/25/2021, 4:41 PMgaryaustin
10/25/2021, 6:07 PMTito
10/26/2021, 2:38 PMawait this.$supabase
.from("votes")
.select("*").eq("project_id", this.project_id)
returns an Array as expected... but If I try to count it, it returns none:
await this.$supabase
.from("votes")
.select("*", { count: "exact", head: true }).eq("project_id", this.project_id)
what am I doing wrong?Tito
10/26/2021, 2:51 PMgaryaustin
10/26/2021, 2:55 PMTito
10/26/2021, 2:58 PMMike92988
10/26/2021, 9:19 PMgaryaustin
10/26/2021, 9:28 PMMike92988
10/26/2021, 9:41 PMMike92988
10/27/2021, 8:58 PMymahmo
10/28/2021, 12:37 PMymahmo
10/28/2021, 12:38 PMymahmo
10/28/2021, 12:54 PMMike92988
10/28/2021, 7:04 PMMike92988
10/29/2021, 12:04 AMdreinon
10/29/2021, 2:00 AMdreinon
10/29/2021, 2:01 AMyourfriend
10/29/2021, 3:49 PMSELECT FOR UPDATE
with the client library?yourfriend
10/29/2021, 4:02 PMyourfriend
10/29/2021, 4:02 PMspiderz
10/31/2021, 1:47 AMtamagoez
10/31/2021, 2:18 AMconst username = async () => {
return await supabase.from('users').select('username').eq('id', user?.id)
}
silentworks
10/31/2021, 2:30 AMjon
11/01/2021, 5:16 PMconst { data, error } = await supabase
.from('cities')
.select('name, country_id')
.or('id.gt.20,and(name.eq.New Zealand,name.eq.France)')
if do:
const { data, error } = await supabase
.from('cities')
.select('name, country_id')
.or('fts_description.fullText.keyword,and(title.eq.New Zealand,name.eq.France)')
I get: failed to parse logic tree