Need help with Client Side filtering of Wijmo Grid

Need help with Client Side filtering of Wijmo Grid

Posted by: nilesh_nichal on 26 June 2022, 8:31 pm EST

• 

  nilesh_nichal

  • Post Options:
  • Link
    Copy

  Posted 26 June 2022, 8:31 pm EST

  Hi Team,

  We are using the Flex grid component and have implemented client side filters for columns.
  
  This filter filters the value based on Contains search. example : If I have column values as Lamborghini, Lancia, Land Rover and the filtertext is “La” - It returns all 3 records and while performing other operations on this filtered data, it results into errors as the results are not exact match

  Our requirement is the filter results should be exact match rather than the contains search.
  
  It should return either no result for filtertext= “La” - 0 records
  
  or an exact match result for filtertext =“Lamborghini” - 1 record

  Is there any way to set filter operation to exact match with the Entered filterText.

  Thanks

• 

  sonu.pandey

  

  • Post Options:
  • Link
    Copy

  Posted 27 June 2022, 4:44 pm EST

  Hello,

  As per our understanding, you are filtering the columns data using the flexGridSeach control, if so then you may refer to the sample link below demonstrating how to perform exact searching on the FlexGrid:

  https://stackblitz.com/edit/js-xpdsoi?file=index.js

  Let us know if that works for you.

  Regards
  
  Sonu Kumar Pandey

• 

  nilesh_nichal

  • Post Options:
  • Link
    Copy

  Posted 27 June 2022, 11:22 pm EST

  Hi,

  We are using the column filters available on the flexGrid itself and there is no reference to the Search Control. Is there any way by that the Column ValueFilter will give results based on exact match of the entered filterText.

  Thanks

• 

  sonu.pandey

  

  • Post Options:
  • Link
    Copy

  Posted 28 June 2022, 9:05 pm EST

  Hello,

  Yes, you can use a similar approach to implement the exact search filtering for the FlexGridFilter’s editor. You can get the underlying ListBox control instance by handling the editingFilter event of FlexGridFilter and perform the searching as per the value entered in the input field placed on valueFilter. Please refer to the sample link below demonstrating the same:

  https://stackblitz.com/edit/js-fexxfb?file=index.js

  Regards