prisma-client-api-filters

// Greater than
where: { age: { gt: 18 } }
 
// Greater than or equal
where: { age: { gte: 18 } }
 
// Less than
where: { age: { lt: 65 } }
 
// Less than or equal
where: { age: { lte: 65 } }
 
// Combined
where: { age: { gte: 18, lte: 65 } }

// In array
where: { role: { in: ['ADMIN', 'MODERATOR'] } }
 
// Not in array
where: { role: { notIn: ['GUEST', 'BANNED'] } }

// Contains
where: { email: { contains: 'prisma' } }
 
// Starts with
where: { email: { startsWith: 'alice' } }
 
// Ends with
where: { email: { endsWith: '@prisma.io' } }
 
// Case-insensitive (default for some databases)
where: { 
  email: { 
    contains: 'PRISMA',
    mode: 'insensitive' 
  } 
}

// Is null
where: { deletedAt: null }
 
// Is not null
where: { deletedAt: { not: null } }
 
// Using isSet (for optional fields)
where: { middleName: { isSet: true } }

// Multiple conditions = AND
where: {
  email: { contains: '@prisma.io' },
  role: 'ADMIN'
}

where: {
  AND: [
    { email: { contains: '@prisma.io' } },
    { role: 'ADMIN' }
  ]
}

where: {
  OR: [
    { email: { contains: '@gmail.com' } },
    { email: { contains: '@prisma.io' } }
  ]
}

where: {
  NOT: {
    role: 'GUEST'
  }
}
 
// Multiple NOT conditions
where: {
  NOT: [
    { role: 'GUEST' },
    { verified: false }
  ]
}

where: {
  AND: [
    { verified: true },
    {
      OR: [
        { role: 'ADMIN' },
        { role: 'MODERATOR' }
      ]
    }
  ],
  NOT: { deletedAt: { not: null } }
}

// Users with at least one published post
where: {
  posts: {
    some: { published: true }
  }
}

// Users where all posts are published
where: {
  posts: {
    every: { published: true }
  }
}

// Users with no published posts
where: {
  posts: {
    none: { published: true }
  }
}

// Users with profile in specific country
where: {
  profile: {
    is: { country: 'USA' }
  }
}
 
// Users without profile
where: {
  profile: {
    isNot: null
  }
}

// Has element
where: { tags: { has: 'typescript' } }
 
// Has some elements
where: { tags: { hasSome: ['typescript', 'javascript'] } }
 
// Has every element
where: { tags: { hasEvery: ['typescript', 'prisma'] } }
 
// Is empty
where: { tags: { isEmpty: true } }

// Path-based filter
where: {
  metadata: {
    path: ['settings', 'theme'],
    equals: 'dark'
  }
}
 
// String contains in JSON
where: {
  metadata: {
    path: ['bio'],
    string_contains: 'developer'
  }
}

// Requires @@fulltext index
where: {
  content: {
    search: 'prisma database'
  }
}