Multiple grouping and sorting issue

[BennyParticipant]

Hi, we have an issue when using grouping in jqxgrid.

Test steps:

1. Go to http://jsfiddle.net/nh0f1jrd/1/
2. Group on First name and on Product
3. Click on Last name to sort on it
4. Expand a group (Andrew (6))
5. Note the sub groups listed (Black Tea(2),Espresso con Panna(2), Caffe Americano(1), Caramel Latte(2), Doubleshot Espresso(2), Peppermint Mocha Twist(1))
6. Go to next page

Expected result:
I should be able to see the rest of the subgroups part of Andrew

Actual result:
A couple of the subgroups in page 1 are listed again on page 2: (Black Tea(1), Espresso con Panna(1), Caramel Latte(1)). This is very confusing.
Looking at page 1 I would expect that in all of my 500 data items I would have only 2 items with “Andrew” and “Black Tea”. But when I go to page 2 I now see that there is another row with “Andrew” and “Black Tea”. I would need to go through all pages to realize how many items there are in a group.

[Peter StoevKeymaster]

Hi Benny,

Grouping groups the Records Per Page when Paging is enabled. This means that you see Groups for Page 1, on Page 2 you see Groups for Page 2 and so on i.e it groups first 10 records, then records from 10-20, ….

Best Regards,
Peter Stoev

jQWidgets Team
http://www.jqwidgets.com

[BennyParticipant]

Hi Peter,

Yes I get that paging is limited to 10 items when I have set that page size, but I am suggesting that Andrew -> Black Tea has in total 3 records. Why can I not see 3 records on page 1? The group “Peppermint Mocha Twist” should then move to next page so that it is still 10 items for first page. See screenshots:

Page 1: https://www.dropbox.com/s/6550b1gwjlwg0km/page%201.png?dl=0
Page 2: https://www.dropbox.com/s/gz8mw9v0h6snef8/page%202.png?dl=0

Also, if I don’t do step 3 in my first post (i.e. I don’t sort on anything), it works as expected. Then I only get one subgroup per parent group no matter if I go to the next pages. So in the example with Andrew -> Black Tea, I clearly see that it has 3 items.

[Peter StoevKeymaster]

Hi Benny,

You didn’t get it. 10 data records are grouped. 10 data records are shown in your 1st and in your 2nd screenshot. The Group Headers are not data records.

Best Regards,
Peter Stoev

jQWidgets Team
http://www.jqwidgets.com

[BennyParticipant]

So what you are saying is that you apply paging before grouping. First the data is divided into the page size of 10.
And after that you apply the grouping, individually per page.

To us it would be more helpful if we can do it the other way around. First apply grouping on all data > then apply paging so that only 10 items are shown.

[Author]

Posts