Column Sort doesn't match Order By Sort

Ninox Profile

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

Ninox Profile

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


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