Prisma

image.png

can anyone see why `expiresAt` filter is not working - it gives me empty [] for entries?

AND: {
                    OR: [{
                        expiresAt:null
                    }, {
                       expires_lt: $dtNow
                    }
]

nope, can't have AND: ... without `where`

the `OR` should be an array of multiple objects?

I'm trying to get "either expiresAt is null OR less than now()"

how about...
```
where: {
  OR: [
    { expiresAt: null },
    { expiresAt_lt: $dtNow },
  ]
}
```

well that's the same where clause I'm using

which is good, you also would have done it this way... but it's nut yielding any results, wonder if there's a bug there?

no check it you use the two expires in the same object

I get same results (entries: [] ) with
```   categories(orderBy: index_ASC) {
      id
      index
      bcolor
      fcolor
      title
      entries(
        orderBy: title_ASC
        where: {AND: [{ OR: [{ expiresAt: null, expiresAt_lt: $dtNow }] }]}
      )```

Are there such entries? :slightly_smiling_face:

ah just looked at your query again. You are still using the wrong syntax.

Compare your query to <https://prisma.slack.com/archives/CA491RJH0/p1540512311000100?thread_ts=1540504629.000100&amp;cid=CA491RJH0> until you see the difference.