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.

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?