Forum

November 2nd, 2014
A A A
Avatar

Lost password?
Advanced Search

— Forum Scope —




— Match —





— Forum Options —





Minimum search word length is 3 characters - maximum search word length is 84 characters

The forums are currently locked and only available for read only access
sp_Feed Topic RSS sp_TopicIcon
Help with grouping
11/11/2010
03:32
Avatar
udx6bs
Member
Members
Forum Posts: 6
Member Since:
31/05/2010
sp_UserOfflineSmall Offline

Hi there,

I'm trying to get grouping working, however. If I change the grouping variable from true to false everything works as it should be.

When change it to true, I get only a "Loading…". Any thoughts here?

My code:

<table id='jqGrid__languages'></table>
<div id='jqGridPager__languages'></div>
<script type='text/javascript'>
  $('#jqGrid__languages').jqGrid({
    'url' : 'admin_en/tabledata/_languages',
    'hidegrid' : false,
    'mtype' : 'post',
    'datatype' : 'json',
    'height' : 'auto',
    'colModel':[
      {'name':'t.id', 'index':'t.id', 'label':'ID', 'edittype':'text', 'editable' : true},
      {'name':'t.name', 'index':'t.name', 'label':'Name', 'edittype':'text', 'editable' : true},
      {'name':'t.enabled', 'index':'t.enabled', 'label':'Enabled', 'edittype':'checkbox', 'format':'checkbox', 'editable' : true, 'editoptions':{'value':'1:0'}},
      {'name':'t.collation', 'index':'t.collation', 'label':'Collation', 'edittype':'text', 'editable' : true},
      {'name':'t.modified', 'index':'t.modified', 'label':'Modified', 'edittype':'text', 'editable' : true},
      {'name':'t.created', 'index':'t.created', 'label':'Created', 'edittype':'text', 'editable' : true},
    ],
    'caption' : 'Edit languages',
    'rowNum' : 50,
    'rownumbers' : true,
    'rowList' :[50,100,200],
    'pager' : '#jqGridPager__languages',
    'sortname' : 't.id',
    'viewrecords': true,
    'gridview' : true,
    'sortorder' : 'desc',
    'sortable' : true,
    'prmNames' : {
      'id' : 'data[options][rowid]',
      'page' : 'data[options][page]', 
      'rows' : 'data[options][rows]', 
      'sort' : 'data[options][sortindex]', 
      'order' : 'data[options][sortorder]',
      'search' : 'data[options][search]',
      'nd' : 'data[options][stamp]',
      'oper' : 'data[options][oper]'
    },
    'ondblClickRow' : function(rowid) {
      $('#jqGrid__languages').jqGrid('editGridRow', rowid, {reloadAfterSubmit:true, width:850, modal:true, mtype:'post', url:'admin_en/send/_languages', closeAfterEdit: true, closeOnEscape:true});
    },
    'grouping': false,
    'groupingView' : {
      'groupField' : ['name'],
      'groupSummary': [true],
      'groupColumnShow': [true],
      'groupText: ['<b>{0}</b>'],
      'groupCollapse: false',
      'groupOrder': ['asc']  
    },  
  });
  $('#jqGrid__languages').jqGrid('navGrid', '#jqGridPager__languages',
    {view:true}, //options
    {reloadAfterSubmit:false, width:850, modal:true, mtype:'post', url:'admin_en/send/_languages', closeAfterEdit: true, closeOnEscape:true}, // edit options
    {reloadAfterSubmit:false, width:850, modal:true, mtype:'post', url:'admin_en/send/_languages', closeAfterAdd: true, closeOnEscape:true}, // add options
    {reloadAfterSubmit:false, jqModal:true, closeOnEscape:true, mtype:'post', url:'admin_en/send/_languages/t.id/SINGLELAN'}, // del options
    {closeOnEscape:true}, // search options
    {height:250,jqModal:false,closeOnEscape:true} // view options
  );

  $('#jqGrid__languages').jqGrid('navButtonAdd','#jqGridPager__languages',{
    caption: '',
    title: 'Reorder Columns',
    onClickButton : function (){
      $('#jqGrid__languages').jqGrid('columnChooser');
    }
  });

  $('#jqGrid__languages').jqGrid('filterToolbar');

</script>

The data sent is:

{"total":"1","page":"1","records":"4","rows":[

   {"id":"1","cell":["hu","Magyar","1","utf8_hungarian_ci","2010-11-11 01:01:16","2010-11-11 01:01:16"]},

  {"id":"2","cell":["en","English","1","utf8_general_ci","2010-11-11 01:01:17","2010-11-11 01:01:17"]},      {"id":"3","cell":["ab","Magyarb","0","utf8_hungarian_ci","2010-11-11 01:01:16","2010-11-11 01:01:16"]},
   {"id":"4","cell":["aa","Magyara","0","utf8_hungarian_ci","2010-11-11 01:01:16","2010-11-11 01:01:16"]}
]
}

I tried my best to make the code readable. Hope it worked.

11/11/2010
18:50
Avatar
udx6bs
Member
Members
Forum Posts: 6
Member Since:
31/05/2010
sp_UserOfflineSmall Offline

Oh it was a mistypo. Solved now

Forum Timezone: Europe/Sofia

Most Users Ever Online: 715

Currently Online:
63 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.com

Moderators: tony: 7721, Rumen[Trirand]: 81

Administrators: admin: 66

Comments are closed.
Privacy Policy   Terms and Conditions   Contact Information