How do I use CompositeFilterDescriptor to set the initial datasource

[Ray]

I am looking to filter the datasource for Grid with a CompositeFilterDescriptor instead of just a FilterDescriptor so I can set the or condition. I can't quite figure out a way to do this using the example on your site as well as playing around with the different constructors for the add method. The add methods only take a FilterDescriptor.  Below is an example from your site, is this possible using the Filter() Method on the grid to asdd

 

@(Html.Kendo().Grid<Product>()
    .Name("grid")
    .DataSource(dataSource => dataSource
        .Ajax()
        .Read(read => read.Action("Products_Read", "Home"))
        .Filter(filters =>
        {
            // Show products whose ProductName property contains "C"
            filters.Add(product => product.ProductName).Contains("C");
            // and UnitsInStock is greater than 10
            filters.Add(product => product.UnitsInStock).IsGreaterThan(10);
        })
    )
)

[Alexander Popov]

Hello,

I would suggest using the Kendo.Mvc.CompositeFilterDescriptor and the AddRange method. For example: 

    ICollection<Kendo.Mvc.CompositeFilterDescriptor> filters = new List<Kendo.Mvc.CompositeFilterDescriptor>();
    filters.Add(new Kendo.Mvc.CompositeFilterDescriptor()
    {
        LogicalOperator = Kendo.Mvc.FilterCompositionLogicalOperator.And,
        FilterDescriptors = new Kendo.Mvc.Infrastructure.Implementation.FilterDescriptorCollection()
        {
            new Kendo.Mvc.FilterDescriptor() { Member = "ProductName", Operator = Kendo.Mvc.FilterOperator.IsEqualTo, Value = "Chai"},
            new Kendo.Mvc.FilterDescriptor() { Member = "Discontinued", Operator = Kendo.Mvc.FilterOperator.IsEqualTo, Value = true},
        }
    });
}
@(Html.Kendo().Grid<Kendo.Mvc.Examples.Models.ProductViewModel>()
    .Name("grid")
    ...
    .DataSource(dataSource => dataSource
        .Ajax()
        .Filter(f=>f.AddRange(filters))

Regards,
Alexander Popov
Telerik

[John]

This helped me very much.  Although i could bind a column with a string field name and even add sorts to one, none of the filter builders accept column names as strings.  This prevented me from pulling them into an extension.  I was able to use your code above to use filterbuilder instead since i can assign the filter by string that way.  Thank you!

 

[Ray]

That seemed to did the trick. Thank you very much!