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

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

Follow these steps to achieve this requirement:

1. Create an expression column with CONTAINS () string function and add the required word in the Substring_expression element. Add more than one word 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 choose the true value to view the filtered data in the Grid widget

   

   

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