Hey Is there any way to perform this query? I have seen atomic operations on the update, does that exist on findMany?

await prisma.offers.findMany({
        where: {
            status: {
                lt: offers.statusValue //based on any other field on that table
            }
        }
    })

@Jijin P Atomic number operations is only for updating values. For

findMany

you can use operators like

lt

and

gt

to compare against a value.

Ok. 😊

For querying against the values on a field, you can use a raw query via

prisma.$queryRaw

as a workaround 🙂

Let me check that.