Author Topic: ParamQuery : Group Rows + Pivot Mode  (Read 63 times)

HardikKumar.Zaveri

  • Pro Ultimate
  • Newbie
  • *
  • Posts: 13
    • View Profile
ParamQuery : Group Rows + Pivot Mode
« on: April 03, 2019, 02:42:36 am »
Hi,

PQ Grid is not performing group by on rows properly when we change the order of columns on group rows section inside Pivot Panel toolbar. I have noticed the similar behavior here on example site here as well.

https://paramquery.com/pro/demos/pivot.  For example, on example site, the group rows are on Sport & Country columns by default. This works well when we open the page.  However, when I try to change group rows order from Country -> Sport to Sport -> Country, the PQ grid shows Country name at both level on first column. Instead, the correct behavior is first column has to show Sport at level 1 and Country at level 2.

Similar type of issue we are facing in our current implementation of Pivoting but for other columns.

Can you please suggest what actions/changes do we need to do so that group rows and pivot works as expected?


Regards,
Hardik Zaveri.


paramquery

  • Administrator
  • Hero Member
  • *****
  • Posts: 3861
    • View Profile
Re: ParamQuery : Group Rows + Pivot Mode
« Reply #1 on: April 03, 2019, 09:40:40 am »
Hi Hardik Zaveri

I'm able to reproduce the issue. I'm moving it to bug log for further testing and fixing of issue in upcoming versions.

Thanks

HardikKumar.Zaveri

  • Pro Ultimate
  • Newbie
  • *
  • Posts: 13
    • View Profile
Re: ParamQuery : Group Rows + Pivot Mode
« Reply #2 on: April 03, 2019, 07:46:29 pm »
Hi,

Thanks for your reply.  Once you will fix the issue, do we need to buy new version or you will give us access to new version which has fix?

paramquery

  • Administrator
  • Hero Member
  • *****
  • Posts: 3861
    • View Profile
Re: ParamQuery : Group Rows + Pivot Mode
« Reply #3 on: April 04, 2019, 08:50:03 pm »
Hardik

you have 1 year subscription to all upgrades and bug fixes.

Regards

paramquery

  • Administrator
  • Hero Member
  • *****
  • Posts: 3861
    • View Profile
Re: ParamQuery : Group Rows + Pivot Mode
« Reply #4 on: April 13, 2019, 10:44:28 pm »
Upon further investigation it turned out not to be a bug.

the issue mentioned in this post can be resolved by adding an unbound column as first column in colModel.

Example: https://paramquery.com/pro/demos/pivot

HardikKumar.Zaveri

  • Pro Ultimate
  • Newbie
  • *
  • Posts: 13
    • View Profile
Re: ParamQuery : Group Rows + Pivot Mode
« Reply #5 on: April 19, 2019, 01:22:20 am »
Thanks for your reply.

Is the first column (Group) behavior correct when you uncheck "pivot" mode? I  can see blank checkbox under sport value on "Group" column.

Chris

  • Pro Ultimate
  • Newbie
  • *
  • Posts: 6
    • View Profile
Re: ParamQuery : Group Rows + Pivot Mode
« Reply #6 on: April 19, 2019, 02:05:29 am »
Thanks for this, it resolved the issue for us.  We did find what may be another bug though.  We have enable the pivot toolpanel as well.  If we load the grid pivoted and then turn the pivot off with the panel the rows are remaining grouped with the titles displayed in the dummy column.  Basically the grid does not revert back to a default display.

paramquery

  • Administrator
  • Hero Member
  • *****
  • Posts: 3861
    • View Profile
Re: ParamQuery : Group Rows + Pivot Mode
« Reply #7 on: April 19, 2019, 12:46:57 pm »
Thanks for checking it out.

Unbound first column to display grouped rows is valid for row grouping ( with or without pivot mode), so it's not an issue.

Also it can be hidden when there are no grouped rows.

Code: [Select]
groupOption: function (evt, ui) {
       //hide Group column when no group rows are present.
       this.getColModel()[0].hidden = !this.option('groupModel').dataIndx.length;
},
« Last Edit: April 19, 2019, 03:08:35 pm by paramquery »