ARArulpriya Ramalingam Syncfusion Team April 7, 2017 12:11 PM UTC
Thanks for using Syncfusion products.
We could able to understand your scenario. The LikeFilterCompareOperator matches the complete string to filter with record values and filters the records if condition satisfied. The record values which contains the filter string along with some values can be filtered using “*” FilterCondition. From your query, we could not able to understand that whether the Column Product description is a single column or three different columns. If it is a single column, the “*” FilterCondition should be used with LikeFilterCompareOperator to filter your requirement. In this case, the filtering cannot be done without using the “*” between the text. Because this is standard way to define the filtering condition to filter the in between text.
If it is three different column, there is no possibility to filter the record values referenced with another column values. In that case, you have provided the details like the filtering has been performed based on the textbox text. Can you please provide your sample code which will help us to understand your scenario clearly and provide better solution at the earliest?