Unplanned
Last Updated: 14 Mar 2024 23:51 by Holger
Holger
Created on: 24 Aug 2018 15:05
Category: Kendo UI for jQuery
Type: Feature Request
12
ToDataSourceResult avoid casting to lower() to enable index use in database
When using a grid against a large table with server side filtering (ToDataSourceResult)

ToDataSourceResult builds a SQL query that converts the search string to UPPER() and therefore prevents the database from using its indexes. As SQL comparison is case insensitive that LOWER() is unnecessary.  

As we have may grids where this is an issue it would be time consuming to build out manual filters for each grid instead of using ToDataSourceResult

This was discussed here and there was no solution at the time:

https://www.telerik.com/forums/grid-filtering-on-text-using-lower-in-sql

I would liek to request an option to tell ToDataSourceResult() not to use LOWER() in the sql?

See ticket #1339310
9 comments
Holger
Posted on: 14 Mar 2024 23:51

This may be done - see possible duplicate: 

https://feedback.telerik.com/aspnet-mvc/1357569-add-case-sensitive-filtering-for-the-mvc-grid-wrapper#

Vincenzo
Posted on: 02 Aug 2023 13:52
A rant is the best I can do at this point since is too late to change components, my fault someone could say, but who can imagine that such a ridicoulus bug live up to 2023 ? Obviously that makes indexed search unusable, but I'm then wondering if most Telerik uers use those components on TOYS TABLE with just some thousnds rows. Unvelievable, I have to write my own filtering system........!
ADMIN
Martin
Posted on: 15 May 2023 19:38

Hello, Holger,

The feature is still not scheduled for implementation. I will discuss the matter with my manager to notify him of the increased interest towards it. Please keep following the thread for a status change.

Regards,
Martin
Progress Telerik

Stay tuned by visiting our public roadmap and feedback portal pages! Or perhaps, if you are new to our Kendo family, check out our getting started resources
Holger
Posted on: 09 May 2023 11:54

Hi Telerik team,

can you please provide an update on implementation plans?

Thanks!

Holger

 

 

Matthew
Posted on: 09 May 2023 07:37
+1 
Peter
Posted on: 09 May 2023 06:43
+1
ADMIN
Martin
Posted on: 06 Aug 2021 09:49

Hello, Holger,

The feature is not yet planned for implementation at this point. Please keep following the thread for further information.

Regards,
Martin
Progress Telerik

Virtual Classroom, the free self-paced technical training that gets you up to speed with Telerik and Kendo UI products quickly just got a fresh new look + new and improved content including a brand new Blazor course! Check it out at https://learn.telerik.com/.

Holger
Posted on: 31 Jul 2021 23:43
Are there any plans to implement case sensitive search? It has been a while since this was requested.  Thank you. 
Vasim
Posted on: 10 Sep 2018 16:06
+1