Supabase is an open source Firebase alternative. Start your project with a Postgres database, Authentication, instant APIs, Edge Functions, Realtime subscriptions, and Storage.

Supabase

Hi! I'm working on a project where I need to use variables to define my request and more precisely one where I could get data for foreign tables. My code is working, except for the part with Order and Range. The returned list contains my foreign tables, but it is not ordered and I think the count doesn't work.

const { data, error, count } = await supabase
        .from(table)
        .select( ajout,{ count: 'exact' })
        .order(orderField, {ascending: ordre[1], foreignTable: foreignTables})
        .range( curseur, (page * 50))
    return { data, error, count }