Multi filtering across many columns

[Matt]

Is it possible to configure the grid to use server filtering with multiple values (ie checkboxes) and have many columns in the filter. e.g.

(ColA = A) and (ColB = B or ColB = BB) and (ColC = C or ColC = CC)

After enabling server filtering on the grid we are using and setting the columns filterable property to include a datasource to read its values from the server, it looks like each column resets any other columns filter, only allowing a single column to contribute to the filter logic.

I notice that the demos for multi checkbox filtering seem to be able to do this, but they are using odata as the data source type for the overall grid.

 

[Nikolay Rusev]

Hello Matt,

 

You can build such filters manually and apply them through the filter method (the link contains the structure of filter descriptors) of the DataSource.

 

When using column filtering, as in this example,  each column will using its field to build filter descriptor. Once filter is build and the user modify the filter for given column, filter menu will attempt to find, by using the field, the column filter descriptor and modify it.

 

When you apply filters on multiple columns then will form a group filter with "and" logic between them. For example if you apply filtering on the above example for columns "Freight" and "ShipName" the following filter descriptor will be build.

 

 

"{
  "filters": [
    {
      "field": "Freight",
      "operator": "eq",
      "value": 1
    },
    {
      "field": "ShipName",
      "operator": "eq",
      "value": "asdas"
    }
  ],
  "logic": "and"
}"

 

 

`I notice that the demos for multi checkbox filtering seem to be able to do this, but they are using odata as the data source type for the overall grid.` - Indeed the demo for Grid / Filter Multi Checkboxes is using OData, but that is not mandatory. Filter descriptors always have same format on client and they are translated to specific format by the parameterMap. In the example the type: "odata" redefines parameterMap which knows how to translate filter expressions to OData v.2.

 

Regards,

Nikolay Rusev

Telerik

 

 

[Matt]

Thanks Nikolay! We are wanting to provide the filtering using kendo filter menu UI that is part of the grid, rather than setting custom filters via code. It seems that the team here changed a few things and now the filter menus on the columns work as we were expecting, when you press the filter button in each column it adds that columns filter values to the grids filter. Clearing removes that column from the grids filter.