ParamQuery grid support forum

General Category => Help for ParamQuery Pro => Topic started by: EPM Solutions on November 29, 2019, 01:01:33 pm

Title: How we can hide the row or rows the contains 0(zero) in a grid?
Post by: EPM Solutions on November 29, 2019, 01:01:33 pm

Hi Team,


Is there a way in param query API to hide all rows that contains zero in row data in pivot and non-pivot mode of grid for selected view name?

Views is a drop down in grid which is modifying the grid as per View name(ex. Test Budget).

I have added a Problem  plunkr and screenshot below please check and give one solution.


Problem URL:
https://next.plnkr.co/edit/XEA8o1s5A4wyBv6W

Title: Re: How we can hide the row or rows the contains 0(zero) in a grid?
Post by: paramvir on November 29, 2019, 11:23:03 pm

There is no standard API for this.

you may try this:

Code: [Select]

dataReady: function(){
  if(viewname == x)
      this.pageData().forEach(function(rd){
        if(rd.orgBudget==0)
          rd.pq_hidden = true
      })
    },

https://next.plnkr.co/edit/SI7MpD4zYNf5TBFb