DEV Community

Olek
Olek

Posted on

1

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)

Billboard image

The Next Generation Developer Platform

Coherence is the first Platform-as-a-Service you can control. Unlike "black-box" platforms that are opinionated about the infra you can deploy, Coherence is powered by CNC, the open-source IaC framework, which offers limitless customization.

Learn more

Retry later