How to sort with case insensitive

nicolas Ortiz

Question

Hi, i want to sort a entity by case insenstive. when i make the sorting, the one with lowers case get at the final.

an example when i do the sorting:

the "b group" should be second, not in that position. I try to add ToUpper() in dinamic sort but still don't work. Thanks in advance.

27 Jun 2019

Nuno Rolo

MVP

Hi,

The ToUpper is an OutSystems function you should use the SQL function.

You are doing this:

SyntaxEditor Code Snippet

List_SortColumn_GetOrderBy(CourseSessionTable.Id,ToUpper( "{OwnGroup}.[GROUP_DESCRIPTION]"))

You should do this:

SyntaxEditor Code Snippet

List_SortColumn_GetOrderBy(CourseSessionTable.Id, "UPPER({OwnGroup}.[GROUP_DESCRIPTION])")

And don't forget to adjust also in the order widget in the Table Record.

27 Jun 2019

1 reply

27 Jun 2019

Show thread

Hide thread

nicolas Ortiz

Hi,

The ToUpper is an OutSystems function you should use the SQL function.

You are doing this:

SyntaxEditor Code Snippet

List_SortColumn_GetOrderBy(CourseSessionTable.Id,ToUpper( "{OwnGroup}.[GROUP_DESCRIPTION]"))

You should do this:

SyntaxEditor Code Snippet

List_SortColumn_GetOrderBy(CourseSessionTable.Id, "UPPER({OwnGroup}.[GROUP_DESCRIPTION])")

And don't forget to adjust also in the order widget in the Table Record.

Thanks Nuno,

is there a way to do it without dinamic sort?

27 Jun 2019

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.