zenakent Comments - Answer Overflow

zenakent

•Created by zenakent on 8/29/2024 in #help-and-questions

is it possible to order a column how I want it?

found the answer. I have to use prisma raw query and have to use order by "case" to have the results sorted the way I want it. so something like

ORDER BY
  CASE
    WHEN at.status = 'D' THEN 1
    WHEN at.status = 'B' THEN 2
    ELSE 3
  END,

4 replies