ToDatasourceResults UPPER option

2 posts, 0 answers
  1. Roy
    Roy avatar
    1 posts
    Member since:
    Nov 2017

    Posted 08 Feb 2018 Link to this post

    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?

  2. Ivan Danchev
    Ivan Danchev avatar
    1999 posts

    Posted 12 Feb 2018 Link to this post

    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.

    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.
Back to Top