DEV Community

Olek
Olek

Posted on

2

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)

A Workflow Copilot. Tailored to You.

Pieces.app image

Our desktop app, with its intelligent copilot, streamlines coding by generating snippets, extracting code from screenshots, and accelerating problem-solving.

Read the docs

👋 Kindness is contagious

Please leave a ❤️ or a friendly comment on this post if you found it helpful!

Okay