Hi there. Sorry in advance if this is an FAQ -- se...
# orm-help
e
Hi there. Sorry in advance if this is an FAQ -- searched through the github issues and couldn't find anything about this. I want to write a query that finds all posts that have more comments than likes. Is this possible without using
prisma.raw
? E.g:
Copy code
prisma.posts.findMany({ where: { comments: { gt: prisma.field('likes') } } })
👍 1
a
I'd like to do that too
r
Hey @Eric McKay 👋 Currently would only be possible with a raw query via
prisma.raw
. Could you create a feature request here stating your use case?
e
Sure thing. Thanks for the response
👍 2