The Data Grid component offers filter operators to set column filter conditions. Wildcard (*) and LIKE (%) operators handle string-type columns, matching values based on specified patterns.
The Excel-like filter helps create complex filter criteria for a column by allowing users to select possible filter values from a checkbox list. Additionally, users can build complex filter criteria using advanced filter option.The Excel/Checkbox filter in the Grid provides an option to load large data sets on-demand during scrolling.
Filter UI and logic for a column is applied based on the column type. It is also possible for the users to define their own custom filter UI and filtering logic for a column to suit their application needs.
Search Data Grid rows using the built-in search box in the toolbar or programmatically. The built-in settings allow users to customize search behavior.