Please follow the below steps to apply the filter for the any column based on the multiple keywords,
Create the table in your SQL server to store the list of keywords to be filtered,
Create the Custom function in the SQL server to find whether the column’s value contains any of the words present in the table which has keywords.
Here, If the
@searchWord contains any one of the Keyword table words, it will
return as ‘1’ otherwise, it will return as ‘0’.
NOTE: You can customize this logic based on your requirements.
By using the created Custom function, you can create the expression like below in our Dashboard Designer,
Configure the created expression column into the widgets. Here, the Expression column added into the Grid widget’s Hidden Column section.
Apply the filter for that Expression column based on the 0 and 1 value.
Here, 1 represents the Column value contains the filter words. 0 represents the Column value not contain the filter words.
Before applying filter in Grid widget,
After applying the filter in Grid widget,
NOTE: In this approach, you don’t need to modify the expression. You just add the new word in your Keyword table alone.