Hey guys, i have followed schema: How i can find c...
# orm-help
s
Hey guys, i have followed schema: How i can find channels where command with some name not exists. Like Commands have
[{ id: '123', name: 'first'}]
, i wan't to find channels where command with
name
second
not exists, but not others channels.
Copy code
model Channel {
  id String @id

  commands           Command[]

  @@map("channels")
}

model Command {
  id String @id @default(dbgenerated("gen_random_uuid()"))
  name         String
  channelId    String
  channel   Channel        @relation(fields: [channelId], references: [id])
  @@map("channels_commands")
}
👀 1
n
Hey 👋 If I understand correctly, It seems you are looking for not operator. Can you have a look and see if that’s what you are looking for?
Let me know if this is what you were looking for.