jqGrid多表列排序

Question

in JqGrid, i enabled the multisort options and in grid view table i am fetching the columns from two table which having foreign key relation. The data is displaying correctly in view but when i sort using marks table columns, its displaying blank details.

only Student table column are getting sorted. the columns from Marks table are not sorting, its giving blank details.

url:'<?php echo $config['ajaxUrlPath'];?>json.php',
datatype: "json",
mtype: 'POST', 
height : 'auto',
colNames : ['Student Name', 'Email','10th %','12th %'],
colModel : [{name : 'name',index : 'name',width:100},
            {name : 'email',index: 'email',width:100},
            {name : 'tenthperc',index : 'tenthperc',width:100},
            {name : 'twelthperc',index : 'twelthperc',width:100},
           ],
rowNum : 10,
rowList : [10,20,30,50,100],
pager : '#pjqgrid',
sortname : 'id',
viewsortcols : [true,'vertical',true],
toolbarfilter : true,
viewrecords : true,
sortorder : "asc",

Answer 1

It seems that you don't use loadonce: true option. So the sorting are implemented in your server code. You should examine exactly the values sidx and sord which send jqGrid to the server in case of multisort scenario. I suppose that your current server code use just the first part of sidx and it's the reason of your problem.