Unplanned
Last Updated: 26 Jul 2023 08:37 by ADMIN
Oliver
Created on: 25 Feb 2022 13:44
Category: KendoReact
Type: Feature Request
3
PivotGrid extended sorting mechanism that covers types such as dates and numbers

Hi,

Unfortunately,  the KendoReact PivotGrid sorting is currently supported only for string values. This means that even if you set the field type to "date", the sorting will still be applied as if the field were a string. You can see that in this example: https://dojo.telerik.com/oZoTuMIC/55

Please extend your sorting mechanism so that the sorting covers types such as dates and numbers too. Please also consider the user's language when implementing this sorting. We receive date fields in the format yyyy-mm-dd and they should then be displayed in the user language in the UI. For example in German dd.mm.yyyy (i.e. 21.11.2021) or in English 11/21/2021. And please offer this feature for local data binding too.

Regards,

Oliver

 

2 comments
ADMIN
Konstantin Dikov
Posted on: 26 Jul 2023 08:37

Hello,

Just a quick follow up for the local data binding. You can define custom "sortValue" of the dimension of the date field to return a different value that will be used for the sorting:

 

Regards,
Konstantin Dikov
Progress Telerik

Stay tuned by visiting our public roadmap and feedback portal pages! Or perhaps, if you are new to our Kendo family, check out our getting started resources!

ADMIN
Konstantin Dikov
Posted on: 28 Feb 2022 18:01

Hi Oliver,

Thank you for submitting the feature request.

The date values are actually string values within the PivotGrid, which is why they are sorted as string. Nevertheless, we will monitor the interest of the item and based on the number of votes we will further investigate the option for introducing sorting over the Date fields.

Best Regards,
Konstantin Dikov
Progress Telerik

Virtual Classroom, the free self-paced technical training that gets you up to speed with Telerik and Kendo UI products quickly just got a fresh new look + new and improved content including a brand new Blazor course! Check it out at https://learn.telerik.com/.