Author Topic: Apply filter to Grid at Pivot mode (Pro 8.1.0)  (Read 1001 times)

nzxgq0

  • Pro Ultimate
  • Newbie
  • *
  • Posts: 25
    • View Profile
Apply filter to Grid at Pivot mode (Pro 8.1.0)
« on: September 17, 2021, 11:41:00 am »
Hello,

Before 8.0.1, I have a workaround for this.
1. turn off the pivot mode for the grid
2. apply the filter to the grid
Code: [Select]
grid.filter({
            oper: 'replace',
            mode: 'AND',
            rules: [
                { dataIndx: 'FacilityName', condition: 'begin', value: filterFacilityName },
            ]
        });
3. turn on the pivot mode for the grid
However, with 8.0.1 and 8.1.0, it seems the workaround is not working any more. At the 2 step, it complains an error of "Uncaught !primary.getDMData".

By the way, the loadState for Pivot mode with filter values is still not working.  The details are at
https://paramquery.com/forum/index.php?topic=4087.0

nzxgq0

  • Pro Ultimate
  • Newbie
  • *
  • Posts: 25
    • View Profile
Re: Apply filter to Grid at Pivot mode (Pro 8.1.0)
« Reply #1 on: September 17, 2021, 12:10:31 pm »
Good news. The workaround is still working if using this to turn off the pivot mode (and to turn on by change the "false" to "true").
Code: [Select]
    if (pivot) {
        grid.Group().option({
            pivot: false
        });
    }

I still like to see the loadState working with pivot mode and filters.