Case statement not allowed in order by in data source

[juliehovet]

I have a data source where I always want the '*DEFAULT' user to be the first row in the grid and then the rest to be alphabetical. I can accomplish this using a case statement in SQL. When I try to add this SQL to Valence, I get an error saying "Order by can only contain column or alias names." Is there another way that I can do this?

Valence Order By Screenshot 2025-05-08 095057.jpg

[Johnny Major]

Create a derived column and then reference the column in the ORDER BY clause

For Example:

SELECT
  cusno,
  cname,
  caddr1,
  ccity,
  cstate,
  czip,
CASE
  cname
    WHEN 'CNX Corporation'
      THEN 1
    ELSE 99
END AS iscnx
FROM
  democmast
ORDER BY
  iscnx