Where In with MongoDB Nested Document

[andrewl94]

Question

I'm trying to do a select where in content must be equal of one of the values of an array, like the example here:

https://www.prisma.io/docs/reference/api-reference/prisma-client-reference#get-user-records-where-the-name-can-be-found-in-the-following-list-saqui-clementine-bob

const getUser = await prisma.user.findMany({
  where: {
    name: { in: ['Saqui', 'Clementine', 'Bob'] },
  },
})

But i'm getting the following error form TypeScript when trying with nested document:

Type '{ type: { in: string[]; }; }' is not assignable to type '(Without<AttributesCompositeFilter, AttributesObjectEqualityInput> & AttributesObjectEqualityInput) | (Without<...> & AttributesCompositeFilter) | undefined'.
Types of property 'type' are incompatible.
Type '{ in: string[]; }' is not assignable to type 'string'.ts(2322)

How to reproduce (optional)

var arrayTypes : string[] = input.materialTypes;
const data = await prisma.page.findMany({
    take: limit,
    skip,
    include,
    where: {
      type:  { 
        type: {
            in: arrayTypes,
         },
       },
    },
    orderBy
});

Prisma schema:

model Page {
  id              String     @id @default(auto()) @map("_id") @db.ObjectId
  title           String
  excerpt         String
  content         String
  slug            String     @unique
  type            Attributes
  tags            String[]
  lang            String
  thumbnailUrl    String?
  authorId        String
  moduleId        String     @db.ObjectId
  module          Module     @relation(fields: [moduleId], references: [id])
  createdAt       DateTime
  updatedAt       DateTime
  files           File[]
  publicationDate DateTime
  authors         Authors[]
  customFields    Json?
  isPublic        Boolean
  isPublished     Boolean
}
type Attributes {
  title String
  type  String
  meta  Json?
}

Expected behavior (optional)

No response

Information about Prisma Schema, Client Queries and Environment (optional)

// Add your schema.prisma

// Add any relevant Prisma Client queries here

• OS:

• Database:

• Node.js version:

• Run prisma -v to see your Prisma version and paste it

[andrewl94]

I figured out not long after posting.
I was missing the relation filter: https://www.prisma.io/docs/reference/api-reference/prisma-client-reference#is

For reference:

var arrayTypes : string[] = input.materialTypes
typeValue = {
  is:{
    type:{in:arrayTypes}
  }
};

[nurul3101]

Thanks for taking the time to share the solution 🚀