Author Topic: How we can hide the row or rows the contains 0(zero) in a grid?  (Read 2652 times)

EPM Solutions

  • Pro Ultimate
  • Full Member
  • *
  • Posts: 182
    • View Profile
How we can hide the row or rows the contains 0(zero) in a grid?
« 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

paramvir

  • Administrator
  • Hero Member
  • *****
  • Posts: 6310
    • View Profile
Re: How we can hide the row or rows the contains 0(zero) in a grid?
« Reply #1 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