I have used telerik radgrid in my application. I have data in the form of queryable collection. I have enablelinqexpression set to true.
So when i use endswith filter i get an expression in the form of : (iif(User == null, "", User).ToString().ToUpper().EndsWith("system".ToUpper()))
Where user is the column name and system is the string that needs to be searched for.
I am passing the filter expression to the where condition of my collection as shown : filteredItems.Where(filterExpression);
My filteredItems collection already have records and also those records that endswith system.
But it still returns zero count or records.
The filter expression is working in case of startswith, is not null, is null. But not working for few of the filters like endswith, contains etc.