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

[Solved] Bot case sensitive filtering

0 Answers 16 Views
Grid
This is a migrated thread and some comments may be shown as answers.
This question is locked. New answers and comments are not allowed.
xrch
Top achievements
Rank 1
xrch asked on 03 Dec 2010, 10:44 AM
Hello,

I am using the Telerik MVC Grid and it seems that its filters are not case sensitive. I want to configure them as case sensitive.

This is my controller code:

        public ActionResult Index()
        {
            entityContext context = new entityContext ();

            var orders = (from order in context.ORDERS orderby (order.REFERENCE) select order);

            ViewModels.OrderViewModel vm = new OrderViewModel();

            vm.orders = orders;

            return View(vm);
        }

In my view, I put

    <%
        Html.Telerik().Grid<MvcApplication.ORDERS>(Model.orders).Name("orders")
             .Sortable()             
            .Pageable()
            .Filterable()           
            .Render();
     %>

When I filter on a text column ("Equals" or "Contains"), the SQL statement generated calls a lower() function on this text column. I want the filters to be case sensitive so it does not use the lower function.
How can I do?

Thank you in advance for your answers.
Tags
Grid
Asked by
xrch
Top achievements
Rank 1
Share this question
or