Is it possible to skip rows from flexgrid filter?

Is it possible to skip rows from flexgrid filter?

Posted by: chetan.shetty on 5 June 2019, 10:14 pm EST

• 

  chetan.shetty

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 5 June 2019, 10:14 pm EST

  Hello,

  I need to skip the last row of the flex-grid from the column filter as it is a row that computes the values of all the rows above it. Is it possible to do so?

• 

  chetan.shetty

  • Post Options:
  • Link
    Copy

  Posted 5 June 2019, 10:19 pm EST - Updated 3 October 2022, 11:01 am EST

  [quote=“chetan.shetty”]
  
  Hello,

  I need to skip the last row of the flex-grid from the column filter as it is a row that computes the values of all the rows above it. Is it possible to do so?
  
  [/quote]

  

  1489×441 53.9 KB

  

  1483×206 39.5 KB

• 

  sharad.tomer

  

  • Post Options:
  • Link
    Copy

  Posted 6 June 2019, 3:32 pm EST

  Hi,

  We cannot skip a row explicitly from showing value in the value filter. What we could do is assign an array of unique values to the value filter of the grid and then the filter will show only the displayed values. Please refer to the following code snippet:

  // create filter for a FlexGrid
  var filter = new wijmo.grid.filter.FlexGridFilter(grid);
  // assign list of unique values to country filter
  var cf = filter.getColumnFilter('country');
  cf.valueFilter.uniqueValues = ["countryA", "countryB"];
  

  You may also refer to the following sample: https://www.grapecity.com/wijmo/demos/Grid/FilteringSearching/Excel-likeFilter/Optimizations/purejs

  API reference:
  
  • uniqueValues: https://www.grapecity.com/wijmo/api/classes/wijmo_grid_filter.valuefilter.html#uniquevalues

  Regards