How to sort with case insensitive

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.

mvp_badge
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.

Nuno Rolo wrote:

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?


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