jQuery Grid Plugin - jqGridForum

29/10/2010
11:29

liny

Member

Members

Forum Posts: 5

Member Since:
29/10/2010

Offline

1

Hi,

Below is my javascript:

                            myGrid=$("#myXXTable").jqGrid({
                                datatype: "local",
                                rowNum:16,
                                colNames:['FACILITY','DEVICE', 'LOT', 'QTY','CUM AGE'],
                                colModel:[ {name:'facility',index:'facility', width:100, sortable:false, hidden: true},
                                    {name:'device',index:'device', width:100, sortable:false, hidden: true},
                                    {name:'lot',index:'lot', width:100, align:"center", sorttype:"string"},
                                    {name:'qty',index:'qty', width:100, align:"right",sorttype:"int"},
                                    {name:'cumAge',index:'cumAge', width:100, align:"right",sorttype:"float"}
                                ],
                                sortname:'cumAge',
                                sortorder:'asc',
                                multiselect: false,
                                caption: "Lot Cum Age Report - " + device
                            });

$('#myXXTable').jqGrid('clearGridData');

                            for(var i=0;i<=cumAgeArray.length;i++)
                            {
                                $("#myXXTable").jqGrid('addRowData',i+1,cumAgeArray[i]);
                            }

After 'addRowData', jqGrid doesn't sort by cumAge asc,

Can someone tell me how to enforce jqGrid to sort data?

Thank you very much.

29/10/2010
12:58

tony

Sofia, Bulgaria

Moderator

Members

Moderators

Forum Posts: 7721

Member Since:
30/10/2007

Offline

2

Hello,

The grid does not know which data act as ID.

Please set key:true for a field that should do this and you will happy or configure the localReader

/jqgridwiki/doku.php?id=wiki:retrieving_data&s[]=localreader#array_data

regards

Tony

For professional UI suites for Java Script and PHP visit us at our commercial products site - guriddo.net - by the very same guys that created jqGrid.

29/10/2010
18:05

liny

Member

Members

Forum Posts: 5

Member Since:
29/10/2010

Offline

3

Hi, Tony,

I modified the javascript:

                            myGrid=$("#myXXTable").jqGrid({
                                datatype: "local",
                                rowNum:16,
                                colNames:['FACILITY','DEVICE', 'LOT', 'QTY','CUM AGE'],
                                colModel:[ {name:'facility',index:'facility', width:100, sortable:false, hidden: true},
                                    {name:'device',index:'device', width:100, sortable:false, hidden: true},
                                    {name:'lot',index:'lot', width:100, align:"center", sorttype:"string", key:true},
                                    {name:'qty',index:'qty', width:100, align:"right",sorttype:"int"},
                                    {name:'cumAge',index:'cumAge', width:100, align:"right",sorttype:"float", firstsortorder:"asc"}
                                ],
                                sortname:'cumAge',
                                sortorder:'asc',
                                multiselect: false,
                                caption: "Lot Cum Age Report – " + device
                            });

$('#myXXTable').jqGrid('clearGridData');

                            for(var i=0;i<=cumAgeArray.length;i++)
                            {
                                $("#myXXTable").jqGrid('addRowData',i+1,cumAgeArray[i]);
                            }

It still doesn't work.

I just want to automative sort "cumAge" column asc after "addRowData", not user click the column to sort on the web page.

Any hint is welcome. Thanks in advance.

30/10/2010
01:20

OlegK

Germany

Member

Members

Forum Posts: 1255

Member Since:
10/08/2009

Offline

4

If you don't want to add information about ids to the data which you add you can force sorting with a simple reloading of grid:

$("#myXXTable").trigger("reloadGrid");

or

$("#myXXTable").setGridParam({rowNum:16}).trigger("reloadGrid");

I hope that it will work.

Best regards

Oleg

01/11/2010
11:42

liny

Member

Members

Forum Posts: 5

Member Since:
29/10/2010

Offline

5

OlegK said:

If you don't want to add information about ids to the data which you add you can force sorting with a simple reloading of grid:

$("#myXXTable").trigger("reloadGrid");

or

$("#myXXTable").setGridParam({rowNum:16}).trigger("reloadGrid");

I hope that it will work.

Best regards

Oleg

Hi,

I don't quite understand what the "add information about ids" is, could you kindly explain more detail? Thank you very much.

01/11/2010
13:38

OlegK

Germany

Member

Members

Forum Posts: 1255

Member Since:
10/08/2009

Offline

6

If every element of your data from cumAgeArray would be have an additional property id you can use data parameter of jqGrid to place the data at the initialization time in the grid. Hot I can see now you use key:true for the lot column. If your evry data row has really unique data in this column, then you don't need use additional property id and just add data: cumAgeArray as additional parameter of jqGrid (I suppose that elements of cumAgeArray has the same properties as the name properties from the colModel).

Best regards
Oleg

01/11/2010
14:16

liny

Member

Members

Forum Posts: 5

Member Since:
29/10/2010

Offline

7

Hi, thanks for your guys.

Finally! Last line code below is the answer.

                            $("#myXXTable").jqGrid({
                                data:cumAgeArray,
                                datatype: "local",
                                rowNum:10,
                                autowidth: true,
                                height:'500',
                                hidegrid:false,
                                deselectAfterSort:false,
                                colNames:['FACILITY','DEVICE', 'LOT', 'QTY','CUM AGE', 'RESIDUAL', 'OTD_TYPE'],
                                colModel:[ {name:'facility',index:'facility', sortable:false, hidden: true},
                                    {name:'device',index:'device', sortable:false, hidden: true},
                                    {name:'lot',index:'id', align:"center", sorttype:"text", key:true},
                                    {name:'qty',index:'qty', align:"right",sorttype:"int"},
                                    {name:'cumAge',index:'cumAge', align:"right",sorttype:"float"},
                                    {name:'residual',index:'residual', align:"center",sorttype:"text"},
                                    {name:'otdType',index:'otdType', align:"center",sorttype:"text"}
                                ],
                                multiselect: false,
                                pager:'#pager',
                                sortname:'cumAge',
                                sortorder:$('input:radio[name=sortBy]:checked').val(),
                                caption: "Lot Cum Age Report - " + device
                            });

                            $("#myXXTable").setGridParam({data:cumAgeArray, rowNum:cumAgeArray.length, sortorder:$('input:radio[name=sortBy]:checked').val()}).trigger("reloadGrid");

01/11/2010
14:42

OlegK

Germany

Member

Members

Forum Posts: 1255

Member Since:
10/08/2009

Offline

8

Sorry liny, but you write no time about any radio button sortBy. If you use some external elements for jqGrid sorting and place the data not one during creating the grid as you write it is absolutely another situation.

If you want reload the grid with new data you should probably place setGridParam inside of 'change' or 'click' event handler. Moreover refreshing of jqGrid indexes with $("#myXXTable")[0].refreshIndex(); could be also required after this data settings.

Regards
Oleg