ParamQuery grid support forum

General Category => Help for ParamQuery Pro => Topic started by: EPM Solutions on April 22, 2019, 03:30:04 pm

Title: Pivot mode Issue- Grouping
Post by: EPM Solutions on April 22, 2019, 03:30:04 pm

Hello Team,

                We have requiretment to change grouping option dynamically using dropdown.

It is working fine in Non-Pivot mode but seems it is not working for Pivot Mode.

Also, after Pivot mode on and off it stops working for Non-Pivot Mode as well.

We create a plunker for better understanding. Please check and give your feedback asap.

https://next.plnkr.co/edit/SppPfMTgEyj1Mvg9?preview

Thanks.

Title: Re: Pivot mode Issue- Grouping
Post by: paramvir on April 23, 2019, 10:12:51 am

Dropdown listener is incorrect in your code.

Please correct it as below.

Code: [Select]

{
            type: 'select',           
            listener:function(evt){             
              this.Group().option({
                dataIndx:$(evt.target).val()? [$(evt.target).val()]: []
              })
            },
            options: [{
                '':'',
                'division': 'Division',
                'Budget_x0020_Year': 'Budget Year'
            }]
}

https://stackblitz.com/edit/paramquery-pivot?file=index.js

Title: Re: Pivot mode Issue- Grouping
Post by: EPM Solutions on April 23, 2019, 06:08:46 pm

Hello Team,

Thanks for your quick and valuable reply. We tried your suggestion in our code and it is working fine.

But now Grouping is not coming in Sorted order.

Please check below image for reference.

Title: Re: Pivot mode Issue- Grouping
Post by: paramvir on April 24, 2019, 09:34:13 am

Please remove sortable: false from column definition and click on header cell to sort it.