0

Column Sort doesn't match Order By Sort

When I used this code...

 

((select Table1) order by Text).Text

 

I noticed that the sort orders aren't the same.

 

Screen Shot 2019-04-07 at 6.51.49 PM

 

This can be fixed using upper(), but I'm curious if that behavior is intentional

2 replies

null
    • Jorg
    • 5 yrs ago
    • Reported - view

    Hi Sean, 

    while the order in the table is not case sensitive, you have the possibillity to have case sensitive order with that function if you wish/need to have it.

    Best, Jörg

    • JCSchell
    • 5 yrs ago
    • Reported - view

    It would be nice if the 'order by' worked in View. It is accepted as lefitimate, but has no effect on the outcome. I would suggest that it should take priority over user selections. including grouping.Screen Shot 2019-11-14 at 12.09.35 PM

Content aside

  • 5 yrs agoLast active
  • 2Replies
  • 2062Views