Hey all. Is it possible to have where params like ? I'm looking at the docs and it seems I can only have 1 of AND, OR, NOT, etc and not more complex logic.

{
  parentId: null,
  userId: 1234
  deletedAt: null,
  filterSize: {
    { filterSize: { lte: 199 }, },
    OR: { filterSize: { gte: 200 } }, { filterSize: { lte: 799 } },
    OR: { filterSize: { gte: 800 } }
  }
}

Docs: https://www.prisma.io/docs/reference/api-reference/prisma-client-reference#and Maybe something like:

AND: {
   OR: [
      { filterSize: { lte: 199 }, },
      { filterSize: { gte: 200 } }, { filterSize: { lte: 799 } },
      { filterSize: { gte: 800 } }
   ]
}

@Paul 👋 It’s totally possible;

{
  parentId: null,
  userId: 1234
  deletedAt: null,
  AND: [
    { filterSize: { lte: 199 }, },
    { OR: { filterSize: { gte: 200 } }, { filterSize: { lte: 799 } }},
    { OR: { filterSize: { gte: 800 } } }
  ]
}

This would work fine.

Cool thanks