This is a migrated thread and some comments may be shown as answers.

ToDatasourceResults UPPER option

1 Answer 28 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Roy
Top achievements
Rank 1
Roy asked on 08 Feb 2018, 08:40 AM
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

Sort by
0
Ivan Danchev
Telerik team
answered on 12 Feb 2018, 07:13 AM
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
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.
Tags
General Discussions
Asked by
Roy
Top achievements
Rank 1
Answers by
Ivan Danchev
Telerik team
Share this question
or