How to apply the filter in the grid widget based on the string presented in the string column

Display the filtered string values in the Gid widget using the Expression column.

Follow these steps to meet this requirement:

1. Create an expression column using the CONTAINS() string function and include the necessary word in the Substring_expression element. Include multiple words using the OR condition.

   Example: IF(CONTAINS([Comment],’good’)=‘true’,‘true’,‘false’)
   

   

2. Configure the Grid widget with the required fields and bind the created expression in the Filters section.
   

   

3. Open the Filters pop-up and then select the correct value to see the filtered data in the Grid widget.
   

   
   

4. Now, view the grid that is showing the filtered data.