When calling ToDatasourceResults it wraps both sides of the filter criteria in LOWER() so that it can do case insensitive queries. We are using it on a DB2 iSeries database and would like to be able to add indexes to improve the performance of the queries.
1. the DB is case sensitive and cannot be changed
2. we can put an upper case index (which would get used) but not a lower case one
I'm looking for some method of changing the LOWER() to UPPER() when using ToDatasourceResults preferably without having to write my own version of it. Is there anywhere in the code that I can override to modify this behaviour?
1 Answer, 1 is accepted
0
Hello Roy,
At present case insensitive queries are performed by default and there is no built-in method that allows to override this behavior. There is a feature request logged in our public Feedback Portal, for adding an option that would allow this behavior to be customized, so we would suggest voting for it. The popularity of a feature request is a factor that influences its approval by the team and its implementation in a future release.
Regards,
Ivan Danchev
Progress Telerik
At present case insensitive queries are performed by default and there is no built-in method that allows to override this behavior. There is a feature request logged in our public Feedback Portal, for adding an option that would allow this behavior to be customized, so we would suggest voting for it. The popularity of a feature request is a factor that influences its approval by the team and its implementation in a future release.
Regards,
Ivan Danchev
Progress Telerik
Try our brand new, jQuery-free Angular components built from ground-up which
deliver the business app essential building blocks - a grid component,
data visualization (charts) and form elements.