Filter datagrid

[Philippe]

Hello,
I try to filter my datagrid like this :

The same filter must be used for 2 properties. But an error is raised when I use the Or method, if I remove the Or, it works but it is not what I want to do because, without the Or method, the composant do an And between the two filters.

.
.
.
                    .Filter(f =>
                        {
                            if(!string.IsNullOrEmpty(Model.FilterByVendor))
                            {
                                f.Add(a => a.Name).Contains(Model.FilterByVendor).Or();
                                f.Add(a => a.VendorNumber).Contains(Model.FilterByVendor).Or();
                            }
                        })
                    .Read(read => read.Action("GetAllVendors", "Vendor"))
                    .PageSize(20)

            )
            .Filterable()
)

[Daniel]

Hello Philippe,

The logic cannot be set to "Or" between different properties when using the Add method. Could be achieved by using the AddRange method to add a composite descriptor e.g.

IList<IFilterDescriptor> descriptors = new List<IFilterDescriptor>();
FilterDescriptor nameDescriptor = new FilterDescriptor("Name", FilterOperator.Contains, "value");
FilterDescriptor vendorDescriptor = new FilterDescriptor("VendorNumber", FilterOperator.Contains, "value");
CompositeFilterDescriptor composite = new CompositeFilterDescriptor();
composite.LogicalOperator = FilterCompositionLogicalOperator.Or;
composite.FilterDescriptors.Add(nameDescriptor);
composite.FilterDescriptors.Add(vendorDescriptor);
descriptors.Add(composite);

.Filter(filter => filter.AddRange(descriptors))

Regards,
Daniel
the Telerik team