**SELF-HOSTED**
Why isn't my order by clause working? In the report interface I entered this:
Because I want it to sort like this:
It continues to sort in alpha order, which is by display column. I tried the clearing the cache in the debug tools and re-login. Has anyone else ever dealt with this?
Ashley Elliott
Database Administrator
St. Louis Symphony Orchestra
314-286-4198
ashleye@slso.org
You are getting an alpha sort because that column is always interpreted as an alpha column regardless of the data type of the underlying table as that column has to support multiple data types.