Hello!

Data in my jqGrid grouped by campaign name. But when I’m trying to order groups by any column, data will be ordered only inside the group. But groups ordered randomly.

 

Code:

$(‘#b-summary__table’).jqGrid({
url: “db.php?action=showbyid&siteid1&limit=10000”,
datatype: “xml”,
height: ‘auto’,
cellLayout: ‘0’,
colNames: [ ‘Кампания’, ‘Ключевое слово’, ‘Показы’, ‘CTR’, ‘Клики’, ‘Цена клика’, ‘Общие затраты’, ‘Лиды’, ‘CV 1’, ‘Продажи’, ‘CV 2’, ‘Выручка’, ‘CPL’, ‘CPO’, ‘ROI’],
colModel: [
{name: ‘campaign_name’, index: ‘campaign_name’, width: 300, align: ‘center’,sorttype:’text’},
{name: ‘key’, index: ‘key’, width: 300, align: ‘center’,sorttype:’text’},
{name: ‘shows’, index: ‘shows’, width: 60, align: ‘center’, summaryType:’sum’, summaryTpl:'{0}’},
{name: ‘ctr’, index: ‘ctr’, width: 35, align: ‘center’, summaryType:’avg’, summaryTpl:'{0}’},
{name: ‘click’, index: ‘clicks’, width: 43, align: ‘center’,summaryType:’sum’, summaryTpl:'{0}’},
{name: ‘clickprice’, index: ‘clickprice’, width: 60, align: ‘center’,summaryType:’avg’, summaryTpl:'{0}’},
{name: ‘totalprice’, index: ‘totalprice’, width: 60, align: ‘center’,summaryType:’sum’, summaryTpl:'{0}’},
{name: ‘leads’, index: ‘leads’, width: 40, align: ‘center’,summaryType:’sum’, summaryTpl:'{0}’},
{name: ‘cv1’, index: ‘cv1’, width: 35, align: ‘center’,summaryType:’avg’, summaryTpl:'{0}’},
{name: ‘sellscount’, index: ‘sellscount’, width: 65, align: ‘center’,summaryType:’sum’, summaryTpl:'{0}’},
{name: ‘cv2’, index: ‘cv2’, width: 35, align: ‘center’,summaryType:’avg’, summaryTpl:'{0}’},
{name: ‘proceeds’, index: ‘proceeds’, width: 62, align: ‘center’,summaryType:’sum’, summaryTpl:'{0}’},
{name: ‘cpl’, index: ‘cpl’, width: 30, align: ‘center’,summaryType:’avg’, summaryTpl:'{0}’},
{name: ‘cpo’, index: ‘cpo’, width: 30, align: ‘center’,summaryType:’avg’, summaryTpl:'{0}’},
{name: ‘roi’, index: ‘roi’, width: 30, align: ‘center’,summaryType:’avg’, summaryTpl:'{0}’},
],
rowNum: 1000,
rowList: [1000,2000,5000,10000],
pagerpos: ‘right’,
grouping: true,
groupingView : {
groupField: ,
groupDataSorted: true,
plusicon: ‘ui-jqgrid-plus-icon’,
minusicon: ‘ui-jqgrid-minus-icon’,
groupSummary : [true],
groupColumnShow : [true],
groupCollapse: true,
groupSummaryPos: ,
groupText : ,
groupOrder: ,
summaryRoundType: ‘fixed’,
summaryRound: 2
}
});

Screenshot:

How can I fix that?