Applying filter to a grid from server-side

[subith]

Kendo.Mvc, Version=2020.3.1118.0

I am trying to apply filter to a grid from server-side. Below is the implementation. 

public static AjaxDataSourceBuilder<T> Configure<T>(this AjaxDataSourceBuilder<T> source, UserGridPreferenceVM userPreferences) where T : class
{
    if (userPreferences.Filter?.Filters != null && userPreferences.Filter.Filters.Length > 0)
    {
        List<FilterDescriptor> filters = new List<FilterDescriptor>();

        foreach (FilterElement filter in userPreferences.Filter.Filters)
        {
            filters.Add(new FilterDescriptor(filter.Field, GetFilterOperator(filter.Operator), filter.Value));
        }

        source.Filter(s =>
        {
            s.AddRange(filters);
        });
    }

    return source;
}

 

I have 2 questions.

1. When the grid loads the filter condition is set but value of the filter is not set.

2. How we can apply Logic operator "And"/"Or" to the filter?

 

Really appreciated if you can help with this issue.

[Georgi]

Hello Subith,

I would suggest you to add the filters through the API of the grid.

e.g.

@(Html.Kendo().Grid<Kendo.Mvc.Examples.Models.OrderViewModel>()
    ...
    .DataSource(dataSource => dataSource
        .Ajax()
        .Filter(x=> x.Add(y=> y.Freight).IsGreaterThan(12).And().IsLessThan(25))
      ...
     )
)

This way, not only the data will be filtered, but the filter UI will reflect the applied filters. Additionally, the above configuration demonstrates how to chain filter expressions with AND/OR.

I hope this helps.

Regards,
Georgi
Progress Telerik