jQuery UI Widgets Forums Grid Multiple grouping and sorting issue

This topic contains 4 replies, has 2 voices, and was last updated by  Benny 8 years, 6 months ago.

Viewing 5 posts - 1 through 5 (of 5 total)
  • Author
  • Multiple grouping and sorting issue #79389

    Benny
    Participant

    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.

    Multiple grouping and sorting issue #79392

    Peter Stoev
    Keymaster

    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

    Multiple grouping and sorting issue #79395

    Benny
    Participant

    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.

    • This reply was modified 8 years, 6 months ago by  Benny.
    • This reply was modified 8 years, 6 months ago by  Benny.
    • This reply was modified 8 years, 6 months ago by  Benny.
    Multiple grouping and sorting issue #79400

    Peter Stoev
    Keymaster

    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

    Multiple grouping and sorting issue #79401

    Benny
    Participant

    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.

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic.