SupabaseJS and select join with count

#supabase #javascript #react #supabasejs

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
    });
  });

Have fun!