How can I achieve Excel/SharePoint filtering in Infragistics grid?

Question

I'm using Infragistics grid and want to filter results. The filter supported by the grid filters based on the text entered, but I want to filter based on a list of checkboxes, like in Excel and SharePoint. How can I achieve this effect??

SharePoint list filters based on which checkboxes are checked.

Answer 1

You can customize the igGrid filtering drop down with your own custom filtering conditions as shown in this sample.

{
    name: "Filtering",
    mode: "simple",
    filterDialogContainment: "window",
    columnSettings: [
    {
        columnKey: "Country",
        customConditions: {
           USA: {
                key: 'USA',
                labelText: 'USA',
                expressionText: "USA",
                filterFunc: filterCountryUSA
           },
           Canada:{
                 key: 'Canada',
                 labelText: 'Canada',
                 expressionText: "Canada",
                 filterFunc: filterCountryCanada
           },
        }
    }
}