[AnalyticalTable]: Question about sorting

[divier320]

Hi, I enabled sorting capabilities on an AnalyticalTable component but it sorts in a case-sensitive way. Is this intended or a bug maybe? I know there's a sortType function where we can customize sorting, but I'm having a different issue if I combine sorting + grouping capabilities, because the sortType function sometimes receives arrays.

Live Example: https://stackblitz.com/edit/github-9dcrlrig?file=src%2FApp.tsx
When sorting by "Full Name" ascending, then the row starting by lower case "a" goes to the end.

[Lukas742]

Hi @divier320

the alphanumeric sort type implements case-sensitive sort per default. This is the default for the standard js sort method for arrays as well.
Sorting uses the row.values[columnId] value, so in case a custom aggregate function, or a sortType that is not outlined by the docs (e.g. "unique") is used, the compare value can become something different than a simple primitive value. In this case a custom sortType is required.

[divier320]

Thanks @Lukas742!