DEV Community

Olek
Olek

Posted on

SupabaseJS and select join with count

Hi, if you are looking for how to get count of the second select in supabase this is your post :)

return supabase
  .from('game')
  .select(`
    id,
    name,
    users(count)
  `)
  .eq('id', id)
  .then(({data, error}) => {
    if (error) {
      return Promise.reject(error.message);
    }

    return Promise.resolve({
      id: data[0].id,
      name: data[0].name,
      usersCount: data[0].users[0].count
    });
  });
Enter fullscreen mode Exit fullscreen mode

Have fun!

Top comments (0)