TTC

Theo's Typesafe Cult•4y ago•

4 replies

Amos

Order results by a nested relation's DateTime with Prisma

I have a

Conversation

Conversation

model which has one-to-many relationship with

Message

Message

s. I want to order the conversations by the most recent message, but it seems Prisma doesn't have a way to do this??? I need pagination so I can't do this after querying either, so is my only solution to write the SQL myself? I get the love for Prisma, but there are so many things missing