[Solved] DataSource parameterMap example

[Jadranko Dragoje]

Hello.
I need to convert kendo sorting and filtering parameters like this:

Instead of this parameters: 
sort[0][field] = title
sort[0][dir] = asc
sort[1][field] = description
sort[1][dir] = asc

I need single orderBy parameter like this:
orderBy = title asc, description desc

Can you show me how can I get this?

$(document).ready(function () {

           convertSort = function (sort) {

               //TODO: Convert sorting parameters.

           };

 

           $("#grid").kendoGrid({

               dataSource: {

                   type: "json",

                   transport: {

                       read: "Read",

                       parameterMap: function (options) {

                           return {

                               page: options.page,

                               pageSize: options.pageSize,

                               orderBy: convertSort(options.sort)

                           }

                       }

                   },

                   schema: {

                       data: "Items",

                       total: "Total"

                   },

                   pageSize: 5,

                   serverPaging: true,

                   serverFiltering: false,

                   serverGrouping: false,

                   serverSorting: true

               },

               pageable: true,

               filterable: false,

               groupable: false,

               sortable: {

                   mode: "multiple",

                   allowUnsort: true

               },

               columns: [

                   { field: "Name", title: "Naziv" },

                   { field: "Title", title: "Naslov" },

                   { field: "Description", title: "Opis" }

               ]

           });

       });

[Jadranko Dragoje]

OK, I think I got it:

convertSortingParameters = function (original) {

    if (original) {

        var converted, sortIndex;

        converted = "";

        for (sortIndex = 0; sortIndex < original.length; sortIndex += 1) {

            if (sortIndex > 0) { converted += ", " }

            converted += original[sortIndex].field + " " + original[sortIndex].dir;

        }

        return converted;

    }

};

Is there a cleaner solution?

[Shannon]

Would be nice to hear if there is a better solution, or at least some docs on how to do this in each of the versions of KendoUI.  

[Kiril Nikolov]

Hello Shannon,

As this is not a behavior that is support built-in you will need to convert the objects yourself. The proposed solution should give you the expected results, but if you stumble upon any issues, please do not hesitate to contact us.

Regards,
Kiril Nikolov
Telerik