CODEWITHSUNDEEP
tablesorter
pierch
pierch

Reputation: 11

JQuery table sorter pager with AJAX - sorting not working ok

I have a problem with JQuery table sorter pager plugin. I am trying to use paging with AJAX call. It seems to work OK for most cases, but I am unable to get the sorting working.

The problem is that when the request is made it always looks like (assuming the code from example here):

http:/mydatabase.com?page=0&size=100&{sortList:col}

just like the last parameter {sortList:col} is never actually replaced with proper sorting column.

If I'm reading the example correctly the request for sortList = [[2,0],[3,0]] should actually look like:

http:/mydatabase.com?page=0&size=100&col[2]=0&col[3]=0

But in my case it never is. Also when I click on the header the sorting is performed, but no request is made.

Is there anything I am missing in the linked example?

EDIT

The first part of my problem has been solved by replacing the plugin with the newest version.

For the second part, I still cannot get a request when clicking (sorting) columns. The ajaxProcessing function is almost exactly the same as in the example here, only headers variable is renamed.

As Mottie sugested I am posting an example result from AJAX call (MS MVC JsonResult):

{
"total_rows":1,
"headers":["Id.","Date","User name","File name","status","Hash","Link"],
"rows":[
    {
        "Id":"21",
        "ReceiveDate":"02.12.2012",
        "UserName":"John Doe",
        "FileName":"test.txt",
        "Status":"",
        "Hash":"4A71FD2E12F7E04ED0C04E17476BD1BC5F823C8F",
        "FileNameLink":"\u003ca style=\"padding-left:10px\" href=\"GetFile?Id=21&fileName=test.txt\"\u003eSave\u003c/a\u003e"
    }]
}

Regards

Upvotes: 1

Views: 1240

Answers (1)

Mottie
Mottie

Reputation: 86483

I apologize, but I didn't get a chance to thoroughly test the latest changes to the pager. Some of the code was written by someone else, so I might have missed something obvious.

Anyway, this might be the bug that is causing you problems. It resets the table to the first page after each sort... I'll have fixed in the next update.

In the pager plugin, lines 460-470 is this code:

.bind('filterEnd.pager sortEnd.pager', function() {
    //Prevent infinite event loops from occuring by setting this in all moveToPage calls and catching it here.
    if ($.data(table, 'pagerUpdateTriggered')) {
        $.data(table, 'pagerUpdateTriggered', false);
        return;
    }
    c.page = 0;
    updatePageDisplay(table, c);
    moveToPage(table, c);
    changeHeight(table, c);
})

Just change the c.page = 0 to this:

if (e.type === 'filterEnd') { c.page = 0; }

and add an e to the function(e).

Upvotes: 1

Related Questions