How do I count foregin table? I want to count

kaguya_room_users

table, I'm doing as below, I query the users that associated with the room, then use

users.length

to get it. Is it the best way to do that?

js
    supabase
      .from<Room>("kaguya_rooms")
      .select("*, media(*), episode(*), users:kaguya_room_users(id)", {
        count: "exact",
      })

Hello ! This thread has been automatically created from your message in a ``few seconds ago``. Pinging @User so that they see this as well! Want to unsubscribe from this thread? Right-click the thread in Discord (or use the ... menu) and select Leave Thread to unsubscribe from future updates. Want to change the title? Use the

/title

command! We have solved your problem? Click the button below to archive it.