jQuery Grid Plugin - jqGridForum

Topic RSS

Related Topics sp_TopicIcon

Grouping is not grouping

Tags: grouping jqgrid

23/02/2013
19:40

davemh

New Member

Members

Forum Posts: 1

Member Since:
23/02/2013

Offline

My jqGrid (version 4.4.4) is not grouping based on field I specify, but is instead repeating fields.

Here is my json data derived from a php-mysql page:

{"rows":[{"domain":"example.com","email":"admin@example.com"},{"domain":"example1.com","email":"dave@example1.com"},{"domain":"example.com","email":"dave@example.com"},{"domain":"example2.com","email":"admin@example2.com"},{"domain":"example2.com","email":"dave@example2.com"}]}

Here is my jqGrid code:

jQuery("#domains").jqGrid({

url:'getDomains.php',

datatype: "json",

height: 'auto',

rowNum: 10,

rowList: [10,20,30],

colNames:['Virtual Domains', 'User'],

colModel:[{name:'domain', index:'domain', width:200},{name:'email', width:200}],

pager: '#domains_div',

sortname: 'domain',

viewrecords: true,

grouping:true,

groupingView : {groupField : ['domain'],groupOrder: ['asc']},

jsonReader : {repeatitems: false },

});

jQuery("#domains").jqGrid('navGrid','#domains_div',{add:false,edit:false,del:false});

</script>

So I would expect the grouping to be:

example.com
- admin@example.com
- dave@example.com
example1.com
- dave@example1.com
example2.com
- admin@example2.com
- dave@example2.com

Instead, I get 5 entries into the grid:

example.com
- admin@example.com
example1.com
- dave@example.com
example.com
- dave@example.com
example2.com
- admin@example2.com
example2.com
- dave@example2.com

Any suggestions? One other note, if I take out the

jsonReader : {repeatitems: false },

The grid never loads completely, but sits at "Loading".

Thanks!

25/02/2013
12:14

tony

Sofia, Bulgaria

Moderator

Members

Moderators

Forum Posts: 7721

Member Since:
30/10/2007

Offline

Hello,

As from the last version you will need to return the grouped data sorted in appropriate manner.

everthing on this is described in the docs - you will need just to read it.

Kind Regards

For professional UI suites for Java Script and PHP visit us at our commercial products site - guriddo.net - by the very same guys that created jqGrid.

All RSS

Forum Timezone: Europe/Sofia

Most Users Ever Online: 715

Currently Online:
31 Guest(s)