UX View Options Sort By not in alphabetical order

[Matt_Hodge1]

View Sort Order not displaying in Ascending or Descending.

In the data I have 4 entries for Status. REPORT, PENDING, CLOSED, CLOSED BY MC. When I try to sort or Group by Status I get them out of order.

Example: Sort By Status–Descending
PENDING
CLOSED
CLOSED BY MC
REPORT

Example: Sort By Status–Ascending
REPORT
CLOSED BY MC
CLOSED
PENDING

Same with GROUP By–

Why is it not in alphabetical order?

[Steve]

If the Status column is of type Enum, the sorting order is determined by the order the Enum values are defIned in the column definition. You can slide them around into a new order using the widget highlighted here:

After:

[Matt_Hodge1]

Thanks, Steve. Only two appear as ENUM as the data is then processed on another app to add actions that change the status. I have a temp fix with a SWITCH virtual column and then sort by that column but then you lose the STATUS word so I added a color.

switch([STATUS],
“REPORT”,1,
“PENDING”,2,
“CLOSED”,3,
“CLOSED BY MC”,4,
5)

This virtual column does not work.
switch([STATUS],
“REPORT”,“1 REPORT”,
“PENDING”,“2 PENDING”,
“CLOSED”,“3 CLOSED”,
“CLOSED BY MC”,“4 CLOSED BY MC”,
5)

[Steve]

Matt_Hodge1:

I have a temp fix with a SWITCH virtual column and then sort by that column but then you lose the STATUS word so I added a color.

What does “then you lose the STATUS word” mean? In a view, a sorting column doesn’t need to be displayed.