Hey so i have this query: ```sql const { data, e...
# sql
s
Hey so i have this query:
Copy code
sql
 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 help
t
I can see how to do it in postgrest using https://postgrest.org/en/latest/api.html#logical-operators
Taking a guess if it was supported this is the logic that I would do something like
Copy code
js
 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.
s
Thanks I'll try