jQuery Grid Plugin - jqGrid - Topic: Sorting and the ID column

slimjim96 on Sorting and the ID column

Mon, 19 Dec 2011 17:31:44 +0200

Whenever a column is selected to be sorted (including the ID column) and the ID column does not contain consecutive numbers, it re-numbers them.

For example, if we have ids listed as 1, 4, 7, 9, 10. After sorting they get changed to 1, 2, 3, 4, 5.

For users who use the id column to represent the IDs in a database, create a second "hidden_id" column and enter them as strings. When referencing them, use the "hidden_id" attribute to get the correct id.

$("#GRID_LIST_ID").jqGrid({

...

data: { id:<%=item.getId()%>, hidden_id:"<%=item.getId()%>"...},

onSelectRow: function(id){

                if(id) {
                    var ret = $("#GRID_LIST_ID").getRowData(id);
                    window.location.href = "page_edit.jsp?edit="+ret.hidden_id;
                }
            }

...

}):

Thanks for your time and overall a great plugin.

Jim