Order By clause is ignoring LowerCase field name

Question

I am trying to use a QoQ, but am running into a problem when
using the order by clause...

All the fieldvalues in the order by field start with
uppercase except for one, and this field name gets thrown to the
end of the list

Anyone got any ideas???

thanks

Sujit

Anonymous · Answer

Before you try the following, please note that you can clean this up in your original DB queries -- which is almost always better.

Anyway, suppose your QofQ was:
SELECT MixcasedColumn
FROM SomeQuerySet
ORDER BY MixcasedColumn

Then you would add a dummy column to use for case-insensitive sort:
SELECT
MixcasedColumn, UPPER (MixcasedColumn) AS SortColumn
FROM
SomeQuerySet
ORDER BY
SortColumn

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded