Filter question

[queensgambit9]

Hi

I would like to clear filter (if exists) on a column when it changes from visible to hidden.
I used this before: https://paramquery.com/forum/index.php?topic=2355

Now using 8.7.0 with updated show / hide functionality how could it be implemented?

[paramvir]

hideCols event can be used for this.

Code: [Select]

hideCols: function(evt, ui){
var grid = this;
ui.diHide.forEach(function(di){
var col = grid.getColumn({dataIndx: di});
if(col.filter && col.filter.crules){
col.filter.crules.forEach(function(rule){
rule.value = undefined; //clear the values while keep the filter conditions.
rule.value2 = undefined;
});
}
});
grid.filter();//refresh filter.
},


[queensgambit9]

Thanks, works fine.

[queensgambit9]

By the way I would like to clear/refresh filter only if filter was set to avoid unnecessary call to db...what would be a good way to do this?

[queensgambit9]

did like this:

Code: [Select]

if (rule.value != undefined || rule.value2 != undefined) {
  rule.value = undefined; //clear the values while keep the filter conditions.
  rule.value2 = undefined;
  grid.filter();//refresh filter.
  }

or is there a better way?

[paramvir]

Code: [Select]

hideCols: function(evt, ui){
var grid = this, requireRefresh;
ui.diHide.forEach(function(di){
var col = grid.getColumn({dataIndx: di});
if(col.filter && col.filter.crules){
col.filter.crules.forEach(function(rule){
                                                    if (rule.value != undefined || rule.value2 != undefined) {
                                                        requireRefresh = true;
rule.value = rule.value2 = undefined; //clear the values while keep the filter conditions.
                                                    }
});
}
});

                               if( requireRefresh ) grid.filter();//refresh filter.
},