STILLWATER;
05/09/2022, 9:32 AMsql
const { data, error } = await supabase_connect
.from('Users')
.select('id,image_url,name,username,age')
// .eq('country', country)
.eq('gender', gender)
.gte('age', age_ll)
.lte('age', age_ul)
// .offset(skip)
.limit(limit);
and i cant use offset (wrong syntax prolly) and i cant find it on website, any helptourdownunder
05/09/2022, 10:59 AMtourdownunder
05/09/2022, 11:04 AMjs
const { data, error } = await supabase_connect
.from('Users')
.select('id,image_url,name,username,age')
.and(or(eq('country', country), is('country', NULL)))
.and(or(eq('gender', gender), is('gender', NULL)))
.gte('age', age_ll)
.lte('age', age_ul)
// .offset(skip)
.limit(limit);
Though I can't find any docs on how its implemented in supabase.STILLWATER;
05/09/2022, 11:23 AM