Hey everyone, I have started with Prisma a few weeks ago, so far I found it interesting I have a scenario where I want to order by nested relation For example, I have the following relation of one-to-many between item and variants

model Item {
id Int
itemName String @map("item_name")
variants Variants[]
}

model Variants {
id Int
unitPrice Decimal @map("unit_price")
item Item
}

NOW I want to sort items by minimum price of any of its variant Is there a way I can achieve it via Prisma client, without using raw query to get my mapped fields in schema P.S: Prisma doesn’t provide option of other fields for nested relation apart from _count

Doesn't that work for you?

await prisma.item.findMany({
  orderBy: {
    variants: {
      unitPrice: 'asc'
    }
  }
})

no it doesn’t provide any such option, I am only able to use _count here @Maciek K

Hmm according to docs it should be possible: https://www.prisma.io/docs/concepts/components/prisma-client/filtering-and-sorting#sort-by-relation

tried them but ain’t working @Maciek K