Filter value unchecked - automatically

Filter value unchecked - automatically

Posted by: sravya_tamma on 11 August 2020, 3:56 pm EST

• 

  sravya_tamma

  • Post Options:
  • Link
    Copy

  Posted 11 August 2020, 3:56 pm EST

  Hi,

  Issue: I have a grid with a column “SOP ID” which has some id’s and “N/A” in the cells. First i filtered all the “N/A” and then added a new id = 100 in the cell, when i add this row disappears from the grid. I have to go to the filter again and check 100 inorder for it to appear in the grid.

  When i type new id into the cell how can i prevent it from unchecking ?

  Below is the screen recording…

  Thanks,
  
  Sravya.

• 

  sravya_tamma

  • Post Options:
  • Link
    Copy

  Posted 11 August 2020, 3:59 pm EST

  Screen Recording .mov.zip

• 

  ashwin.saxena

  

  • Post Options:
  • Link
    Copy

  Posted 12 August 2020, 8:18 am EST

  Hi Sravya,

  This behavior is by design and is same as that of Ms-excel. Whenever a new value will be added/edited in the grid, it will be filtered out. But, you can prevent this by using the CollectionView’s refreshOnEdit property. Setting its value to false will not filter out the newly edited value but it will still be unchecked in the filter.

  API: https://www.grapecity.com/wijmo/api/classes/wijmo.collectionview.html#refreshonedit

  Note that this property was added in 5.20193.637 version. So, in order to use it, you will need to upgrade to at least this version.

  Regards,
  
  Ashwin