Infotable sort function case sensitive

[nparikh]

Hello,

Infotable sort function returns case sensitive result when sorted on column which has string data type.

var params = { sortColumn: "column1", t: "myinfotable", ascending: true };

var result = Resources["InfoTableFunctions"].Sort(params);

Is there a way to sort infotable keeping sort type case insensitive ? or work around ?

Thingworx version - Thingworx v 7.2.6-b76

[CarlesColl · Accepted solution]

Create a new column with Derive snippet where you set it to fieldName.toLowerCase() and sort by this column.