Forum


03:46

07/06/2010

Hi I'm using jqGrid 3.7.2, and it seems sorting doesn't work on a local data especially after add and reloadAfterSubmit: false and reloadonce is true. The added row with specifi ID will always be ontop and it cannot sort base on a value itself. Is there a way to overcome this issue?
jQuery(document).ready(function(){
jQuery("#omg").jqGrid({
url: 'try_js.php',
datatype: "xml",
height: 500,
viewrecords: true,
colNames:['Cust ID','Emp ID', 'Desc', 'Seq No','Items'],
colModel:[
{name:'cust_id',index:'cust_id', width:90, sorttype:"int", editable:true, editoptions:{readonly:true,size:10}},
{name:'emp_id',index:'emp_id', width:100, editable:true, editrules:{integer:true, required:true, custom:true, custom_func:checkempid}, editrules:{integer:true, required:true},editoptions:{size:10}},
{name:'desc',index:'desc', width:500, editable:true, edittype:'textarea', editoptions:{size:20, readonly:true}},
{name:'seq_no',index:'seq_no', width:80, align:"right", sorttype:"int", sortable: true, editable:true, editrules:{integer:true, required:true}, editoptions:{size:20}},
{name:'items_id,index:'items_id', width:80, align:"right", editable:true, editoptions:{size:20}},
],
sortname: "seq_no",
sortorder: "asc",
loadonce: true,
rowNum: '50',
autowidth: true,
pager: "#pagerme",
editurl: "getData.php",
});
jQuery("#omg").jqGrid('navGrid','#pagerme',{view:false, edit:false, add:true, del:true},
{height:350,reloadAfterSubmit:false,closeOnEscape:true}, //edit function
{height:350,reloadAfterSubmit:false,addedrow:'first',closeAfterAdd:true, checkOnUpdate:true}, //add function
{height:350,reloadAfterSubmit:false,closeOnEscape:true} //delete function
);
});
Most Users Ever Online: 715
Currently Online:
60 Guest(s)
Currently Browsing this Page:
1 Guest(s)
Top Posters:
OlegK: 1255
markw65: 179
kobruleht: 144
phicarre: 132
YamilBracho: 124
Renso: 118
Member Stats:
Guest Posters: 447
Members: 11373
Moderators: 2
Admins: 1
Forum Stats:
Groups: 1
Forums: 8
Topics: 10592
Posts: 31289
Newest Members:
, razia, Prankie, psky, praveen neelam, greg.valainis@pa-tech.comModerators: tony: 7721, Rumen[Trirand]: 81
Administrators: admin: 66