[Solved] sort on hidden column

[Guillaume]

Is there a way to sort on a hidden column instead to the visible column?

I need to sort on a datetime with a specific format but it doesn't work as it's a string

 

thank

[Alexander Popov]

Hello Guillaume,

Yes, the DataSource can be order by a field of your choice using the sort method.

Regards,
Alexander Popov
Telerik

 

 

[Santosh]

Hi Alexander,

I want to Sort a date column (which is displaying as string type) with value of other hidden column. As mentioned below

 LastCurDate: { type: "string" },
 dtLastCurDate: { type: "string" }

AND 
                    {
                        field: "dtLastCurDate", title: "Last Current", filterable: { multi: true, dataSource: [{ dtLastCurDate: 'Less than 14 days' }, { dtLastCurDate: 'Between 14 to 30 days' }, { dtLastCurDate: 'More than 30 days ago' }], checkAll: false }, sortable: true,
                        template: "<div class=\"displayInlineBlock\" style='width:140px;'>${LastCurrentDate}</div>"
                    },

[Konstantin Dikov]

Hi Santosh,

I will share the answer from the support ticket for other convenience:

"In order for the values to be sorted as dates you will have to define the type as a date or define custom sorting function as documented in the following help article:
http://docs.telerik.com/kendo-ui/api/javascript/ui/grid#configuration-columns.sortable.compare"

If other questions arise on this matter we can continue the conversation in the support ticket.


Regards,
Konstantin Dikov
Progress Telerik