Ordering an isa relationship | Prisma | Page 1

for reference:

enum AddressType {
  PRIVATE
  COMPANY
}

model Address {
  id      Int        @id @default(autoincrement())
  type    PersonType
  Person  Person?
  Company Company?
}
 
model Private {
  id        Int        @id @default(autoincrement())
  firstname String
  lastname  String
  Address   Address   @relation(fields: [addressId], references: [id])
  addressId Int       @unique
}

model Company {
  id        Int        @id @default(autoincrement())
  name      String 
  Address   Address   @relation(fields: [addressId], references: [id])
  addressId Int       @unique
}

I'm trying to order my addresses by name but this doesn't work because they're optional.

const addresses = await prisma.address.findMany({
  orderBy: [
    { Person: { lastname: 'asc' } },
    { Company: { name: 'asc' } },
  ],
});

#Ordering an isa relationship