Filtering is broken for some values... again

[iCognition]

I've reported this before on the forum and through support tickets.

If you have a grid column with the name "Fields[3].Value" Kendo throws an exception unnecessarily when trying to filter on it.

This can be fixed by adding a period to the list of accepted characters in the FilterLexer. I've done this myself a few times and I'm a bit tired of having to rebuild it every time Kendo gets updated...

 

Expected token
at Kendo.Mvc.Infrastructure.Implementation.FilterLexer.Tokenize()
   at Kendo.Mvc.Infrastructure.Implementation.FilterParser..ctor(String input)
   at Kendo.Mvc.Infrastructure.FilterDescriptorFactory.Create(String input)
   at Kendo.Mvc.UI.DataSourceRequestModelBinder.BindModel(ControllerContext controllerContext, ModelBindingContext bindingContext)
   at System.Web.Mvc.ControllerActionInvoker.GetParameterValue(ControllerContext controllerContext, ParameterDescriptor parameterDescriptor)
   at System.Web.Mvc.ControllerActionInvoker.GetParameterValues(ControllerContext controllerContext, ActionDescriptor actionDescriptor)
   at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>c__DisplayClass21.<BeginInvokeAction>b__19(AsyncCallback asyncCallback, Object asyncState)

[iCognition]

namespace Kendo.Mvc.Infrastructure.Implementation
{
    using System;
    using System.Collections.Generic;
    using System.Text;

    public class FilterLexer...

        private static bool IsIdentifierPart(char character)
        {
            return char.IsLetter(character) || char.IsDigit(character) || character == '_' || character == '$' || character == '[' || character == ']';
        }

[Rosen]

Hello Matt,

Such expression (which uses indexer) is not supported for filtering as it may not be translated by the QueryableProviders. If this is working on your side I suspect that the processing is done in-memory (using LinqToObjects).

Regards,
Rosen
Telerik

[MARCO]

Good Day,

how didi you access the FilterLexer class ?

thanks

Marco

[MARCO]

Rosen Can you help out ?

I don't understand if we have a fix for this issue, I have the same problem, thanks

Marco

[Nikolay]

Hello Marco,

The names of the fields used for columns must be valid JavaScript identifiers. A valid identifier must not contain. For a more detailed description of what characters are accepted in an identifier check out the blog post below:

• https://mathiasbynens.be/notes/javascript-identifiers-es6

Furthermore, there is a JavaScript variable name validator you can use to check if a name is a valid identifier.

• https://mothereff.in/js-variables

Once a valid name is provided for the columns the Grid including the operations as filtering, sorting etc. shall work just fine.

Please let m know if you have any questions.

Regards,
Nikolay
Progress Telerik