FlexGridFilter Various Issues or Questions

FlexGridFilter Various Issues or Questions

Posted by: brijeshkumar.marand on 18 February 2020, 7:14 am EST

• 

  brijeshkumar.marand

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 18 February 2020, 7:14 am EST

  Hello,

  We have implemented the flexGridFilter and I have some issues/questions about how the filter behaves currently.

  I have tried using the demo from the flexGrid.

  Scenario 1: Filter by value the id column by searching the id with ‘1’ and un checking the ‘1’ option. The grid now filters ‘1’ and all data that does not have the ‘1’ in the id like ‘2’, ‘3’, etc.

  Expectation: Filter just the value id ‘1’.

  Scenario 2: The filter by value does not contain all the values like ‘0’ to ‘999’ instead it shows ‘0’ to ‘249’

  Expectation: The filter value should show all the values

  Scenario 3: The filter by value, uncheck ‘Select All’ option and apply. It does not filter anything.

  Expectation: All the values should be filtered

  Please check this and suggest the right way to do this.

  Thanks,
  
  Brijesh

• 

  ashwin.saxena

  

  • Post Options:
  • Link
    Copy

  Posted 19 February 2020, 3:00 am EST

  Hi Brijesh,

  Scenario 1: This behavior also exists in Excel and since FlexGrid is based on Excel, this behavior also exists in FlexGridFilter. You can disable this by setting the exclusiveValueSearch property of FlexGridFilter to false:

  var filter = new wjGridFilter.FlexGridFilter(theGrid, {
      exclusiveValueSearch: false
  });
  

  https://www.grapecity.com/wijmo/api/classes/wijmo_grid_filter.flexgridfilter.html#exclusivevaluesearch

  Scenario 2: This is because the ValueFilter only shows the first 250 values by default. You can change this value by setting the maxValues property of the ValueFilter class. Refer to the documentation link below:

  https://www.grapecity.com/wijmo/api/classes/wijmo_grid_filter.valuefilter.html#maxvalues

  Scenario 3: This is also the same behavior as Excel. If we de-select all the values, there are no rows to filter out. That is why the FlexGrid shows all the rows again.

  I hope this clears your doubts. Let us know in case you have any further issues or queries.

  Regards,
  
  Ashwin