jQuery Grid Plugin - jqGrid

Hi guys, I am using the jqgrid multisort for a project. My requirement is to sort the grid using a minimum of 1 and a maximum of 3 colums and always in ascending order. At the moment, when I am using the following method,

/*

jQuery("#grid")

.jqGrid('sortGrid', "Field1″, true, "asc")

.jqGrid('sortGrid', "Field2″, true, "asc");

*/

sorting happens correctly for the first time, but on second sort jqgrid automatically gets sort in descending order and on the 3rd sort the original condition (presort state) of jqgrid is restored. Please suggest me some way of fulfilling this requirement.

Thanks and Regards.

Hi Tony, thanks for such a quick reply!

This is how I have am doing it on my jsp -

When the user wants to sort the grid on multiple columns, she has to press a sort button provided on the screen. This will take her to a pop up window where all the columns of the grid by the name are shown. From these columns, she can select 1, 2 or 3 columns for sorting. An 'ok' button on the pop up will take her back to the main page. After this I execute the rest of the method. If she had selected only one field for sorting, I execute the follwing -

jQuery("#grid").jqGrid('sortGrid', "Field1″, true, "asc");

If she had selected 2 fields then I execute the following -

jQuery("#grid").jqGrid('sortGrid', "Field1″, true, "asc").jqGrid('sortGrid', "Field2″, true, "asc");

If she had selected 3 fields then I execute the following -

jQuery("#grid").jqGrid('sortGrid', "Field1″, true, "asc").jqGrid('sortGrid', "Field2″, true, "asc").jqGrid('sortGrid', "Field3″, true, "asc");

Now when she does any of these three actions for the very first time, everything is executed correctly, however if she tries to execute the 3rd action, for instance, second time, even though I have explicitley mentioned 'asc' as the sort criteria, the grid would sort in descending order and when the same action is done for a 3rd time the grid is restored to it's first time load state(unsorted state). After this the cycle repeats itself.

Hope this will help you in detecting the root cause of the problem.

Thanks again!

Hi Tony, Even i am facing same problem just like steve. jqgrid always gives precedence to left most column for multisort.i was looking in detail at jquery.jqgrid.js for multi sort and what i felt that it always look at in colmodel sequence to append sort name . line 2239

ts.p.sortorder = "";
            $.each(cm, function(i){
                if(this.lso) {
                    if(i>0 && fs) {
                        sort += ", ";
                    }
                    splas = this.lso.split("-");
                    sort += cm[i].index || cm[i].name;
                    sort += " "+splas[splas.length-1];
                    fs = true;
                    ts.p.sortorder = splas[splas.length-1];
                }
            });
            ls = sort.lastIndexOf(ts.p.sortorder);
            sort = sort.substring(0, ls);
            ts.p.sortname = sort;

ts.p.sortname = sort; - this is always will be Left columm asc/desc, Right column asc/desc

No matter if you have sort order with Field2(right col), Field1(left col).

 

I also tried to change ts.p.sortname to proper sequence based on header click, though data is not sorting the way we click header. it always sorts left column and then right column.

Am i missing something here? trying to fix that issue but no luck. do you have any updates?

hey tony thanks for reply. but does it means we can not do reverse multisort with current version? if so is there any workaround for now?