Prisma-client-js: Error occurred during query validation & transformation

Created on 19 Aug 2020 · 2Comments · Source: prisma/prisma-client-js

Bug description

Somehow the following query produces the following error: Error occurred during query validation & transformation

How to reproduce

const users = await prisma.user.findMany({
  where: {
    participants: {
      some: {
        registrations: {
          some: {
            eventOptionId: {
              equals: 'tl202007-rsb1'
            }
          }
        }
      }
    }
  },
  select: {
    id: true
  }
})

Query (object)
  ↳ findManyUser (field)
    ↳ where (argument)
      ↳ UserWhereInput (object)
        ↳ participants (field)
          ↳ ParticipantListRelationFilter (object)
            ↳ is (field)
              ↳ Field does not exist on enclosing type.` at `.Query.findManyUser.where.UserWhereInput.participants.ParticipantListRelationFilter.is`

Expected behavior

I expect this query to show me a list of users who participated via registrations in at least one particular event option.

Prisma information

model User {
  participants   Participant[] @relation("RUserToParticipants")
}

model Participant {
  registrations Registration[] @relation("RParticipantToRegistrations")
  user          User           @relation("RUserToParticipants", fields: [userId], references: [userId])
  userId        String
}

model Registration {
  eventOption       EventOption      @relation("REventOptionToRegistrations", fields: [eventOptionId], references: [eventOptionId])
  eventOptionId     String
  participant       Participant      @relation("RParticipantToRegistrations", fields: [participantId], references: [participantId])
  participantId     String
}