Sort bound field on grid by different property

[Mark]

Hi there,

 I am trying to get an MVC Kendo UI Grid on the sorting event of a particular column to sort by a different property in the bound model class.  Is this possible - I've tried defining the Sortable comparer (http://docs.telerik.com/kendo-ui/api/javascript/ui/grid#configuration-columns.sortable.compare) but can't seem to get the syntax working.  Below is my cshtml view code - for the SampleResultsOverview column I need the sort value to be bound to a different property on the site model instead - the property is called SampleResultsOverviewSortOrder.

Many thanks, Mark.

 

 .Columns(columns =>
    {
        columns.Bound(site => site.UPRN).Title("UPRN");
        columns.Bound(site => site.AddressWithPostcode).Title("Address");
        columns.Bound(site => site.Contact).Title("Contact");
        columns.Bound(site => site.Telephone).Title("Telephone");
        columns.Bound(site => site.SampleResultsOverview).Title(@RecActionHeader).Encoded(false).Sortable(
            compare: function (a, b) {
            return numbers[a.name] - numbers[b.name];
        );
        columns.Template(site => { }).ClientTemplate(" ").Title("Site Documents");
    })

[Dimiter Madjarov]

Hello Mark,

Specifying a sortable compare function is not supported in the MVC Grid. In the current case I would suggest to bind the column to the field that it should be sorted by and display what is needed via template.
E.g.

columns.Bound(p => p.ProductID).ClientTemplate("#=ProductName#");

Regards,
Dimiter Madjarov
Telerik

[Mark]

Thanks, worked perfectly :)

[Daniel]

Hello Dimiter,

The display of the column using the Client Template works however when grouping by this column (dragging it to the grouping section) or exporting to Excel, it uses the ID. How can I display the client template instead of the ID when grouping by that column or exporting to Excel?

Dan

[Alex Hajigeorgieva]

Hi, Daniel,

To group by the field which is being shown to the user, you may intercept the Kendo UI Grid group event and change the group field:

https://docs.telerik.com/kendo-ui/api/javascript/ui/grid/events/group

.Events(e=>e.Group("onGroup"))
 <script>
     function onGroup(e) {
         var groupsLength = e.groups.length;
         if (groupsLength) {
             if (e.groups[groupsLength - 1].field === "ProductID") {
                 e.groups[groupsLength - 1].field = "ProductName";
             }
         }
     }
 </script>

As far as the excel export is concerned, once the grouping is intercepted and altered, the Excel will also export the current data source view.

Let me know in case further questions arise.

Kind Regards,
Alex Hajigeorgieva
Progress Telerik