Kendo Grid Filtering Case Insensitivity

[Bill]

Hi Kendo,

I'm trying to make filtering for one 'term' case insensitive.   The code below works if the 'tolower' is removed.  What I'm trying to do is pass on through the odata to the database the idea that it needs to take the database column and apply a 'lower case' to it and then do the substring operation, making the filter case insensitive.  Is there any way to get the 'tolower' on the field to work with filtering?  Thanks for your help.

Bill

parameterMap: function (data, type) {
     if (type == "read") {
          var grid = $("#grid").data("kendoGrid");
          var currentFilter = grid.dataSource.filter();
          if (currentFilter) {
                if (currentFilter.filters[1] === undefined & currentFilter.filters[0].field !== "Field1" &             currentFilter.filters[0].field !== "Field2" & currentFilter.filters[0].field !== "Field3") {
                    data.filter.logic = "or";
                    var stringValue = "";
                    stringValue = currentFilter.filters[0].value.toString();
                    var new_filter = { field: tolower(currentFilter.filters[0].field), operator: currentFilter.filters                [0].operator, value: stringValue.toLowerCase() };
                    data.filter.filters.push(new_filter);
                    new_filter = { field: currentFilter.filters[0].field, operator: currentFilter.filters[0].operator, value:          stringValue.toUpperCase() };
                    data.filter.filters.push(new_filter);
}
}

var newMap = kendo.data.transports.odata.parameterMap(data);
delete newMap.$format; // not currently supported by webapi.
return newMap;
}
}

[Bill]

Modified the following line and it fixed the problem and it now works...

var new_filter = { field: "tolower(" + currentFilter.filters[0].field + ")", operator: currentFilter.filters[0].operator, value: stringValue.toLowerCase() };

[Bill]

Here's a more complete solution for the Kendo grid filtering case insensitivity using odata.  Hope it helps somebody else out there working on the same issue...  Using the parameterMap and then looping through the filter collection is the trick.  And filtering collection may have sub collections of filters.  Adding the 'tolower' to the field and then lower casing the filter value does the trick...

$("#grid").kendoGrid({
    dataSource: {
    type: "odata",
    transport: {
     read: {
           url: url,
           dataType: "json",
           headers: { "Accept": "Application/json; odata=verbose" }
     }
     ,
    parameterMap: function (data, type) {
         if (type == "read") {
             var grid = $("#grid").data("kendoGrid");
             var currentFilter = grid.dataSource.filter();
             if (currentFilter) {
                for (var index in data.filter.filters) {
                    if (data.filter.filters[index].field !== "PersonName" & data.filter.filters[index].field !== "PersonJob" &                          data.filter.filters[index].field !== "PersonFun") {
                       if (data.filter.filters[index].field !== undefined) {
                             data.filter.filters[index] = {
                                  field: "tolower(" + data.filter.filters[index].field + ")",
                                  operator: data.filter.filters[index].operator,
                                  value: data.filter.filters[index].value.toLowerCase()
                            }
                       }
                      else {
                           for (var index2 in data.filter.filters[index].filters) {
                               if (data.filter.filters[index].filters[index2].field !== "PersonName" & data.filter.filters         [index].filters[index2].field !== "PersonJob" & data.filter.filters[index].filters[index2].field !== "PersonFun") {
                                    if (data.filter.filters[index].filters[index2].field !== undefined) {
                                         data.filter.filters[index].filters[index2] = {
                                                field: "tolower(" + data.filter.filters[index].filters[index2].field + ")",
                                                operator: data.filter.filters[index].filters[index2].operator,
                                                value: data.filter.filters[index].filters[index2].value.toLowerCase()
                                               }
                                   }
                           }
                     }
              }
         }
      

}

        var newMap = kendo.data.transports.odata.parameterMap(data);
        delete newMap.$format; // not currently supported by webapi.
        return newMap;
}
}
},

pageSize: 100,
serverPaging: true,
serverFiltering: true,
serverSorting: true