**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
Ashley,
I dealt with this last year with a utility I was writing. For whatever reason, it just does not respect the ID column. Fortunately for you in this case, the "gid" column is also in the same order. Use that. That is what I did, and it works just fine (though I had to delete and add in an additional one for myself because I had created them in the wrong order there).
John
Thank you, John!