Server Sorting

[Scott Rakestraw]

I have server sorting working but when I set allowUnsort to true it will always pass in the last sort when clicking on a column for the third time.  So it goes asc, desc, then the it appears to not be sorting on anything but it is actually still passing in the desc sort to the webservice.

[Rosen]

Hello Scott,

I'm afraid that I'm unable to recreate such behavior locally. Therefore it will be appreciated if you could provide a small sample in which  this could be observed.

All the best,
Rosen
the Telerik team

[Scott Rakestraw]

Just an update to this, I don't have an example but I do see when I debug the kendo js in query: function(options) that options.sort contains one item with the correct column name and a dir of undefined.  I'm not sure if that is normal behavior or is a symptom of the problem.

[Scott Rakestraw]

I also noticed for paging I don't have to setup my data call to pass in take, skip etc they are automatically appended but if I don't setup up sort as a parameter it does not get added on the initial call.

[Rosen]

Hi,

Indeed, the sort with field name and empty direction is valid and after processing the descriptor should be ignored and not passed to the server.
Note that you may reassign the names of the parameters send to the server by using transport's parameterMap function as shown in the documentation.

Regards,
Rosen
the Telerik team

[Jignesh]

Hello,

Solution:

var dataSource = new kendo.data.DataSource({
     transport: {
       read: "Catalog/Titles",
       parameterMap: function(options) {
          return {
             pageIndex: options.page,
             size: options.pageSize,
             orderBy: convertSort(options.sort)
          }
       }
     }
 });
var prevSort = "";
function convertSort(sort) {
        if (sort != null) {
            if (sort[0].dir == "desc") {
                if (prevSort == "desc")
                    sort[0].dir = "new";
                else
                    sort[0].dir = "desc";
            }
            prevSort = sort[0].dir;
            return sort;
        }
        return null;
    }

Thanks,
Jignesh Ramavat