Sort by nulls - Prisma

Prisma•2y ago•

1 reply

Sort by nulls

Is there a way to sort and not show nulls or empty strings? I added last: null, but it doesn't work :

this.prisma.toSource.findMany({
  where,
  take: takeCount,
  skip: skipCount,
  orderBy: [
    {
      [dto.orderBy.value]: {
        sort: dto.orderBy.direction,
        nulls: 'last'
      }
    },
    { TITLE: { sort: 'asc', nulls: 'last' } },
    { ID_CONCURRENT: { sort: 'asc', nulls: 'last' } }
  ]
}),

this.prisma.toSource.findMany({
  where,
  take: takeCount,
  skip: skipCount,
  orderBy: [
    {
      [dto.orderBy.value]: {
        sort: dto.orderBy.direction,
        nulls: 'last'
      }
    },
    { TITLE: { sort: 'asc', nulls: 'last' } },
    { ID_CONCURRENT: { sort: 'asc', nulls: 'last' } }
  ]
}),