Multiple filters on one column

[Matthew]

Hello,

Is it possible to apply multiple filters onto the same column. Like this

$("#SearchGrid").ejGrid("filterColumn", [{ field: "Type", operator: "contains", value: "B", predicate: "and", matchcase: false }, { field: "Type", operator: "contains", value: "B", predicate: "and", matchcase: false }]);

What I am attempting is to show rows of "Type" that contain "A" and also contain "B". 

[Manivannan Padmanaban]

Hi Matthew, 

We have achieved your requirement kindly refer the below code example, 

 

    <button id="btn" onclick="Filter()"> 

        Click here to filter 

    </button> 

………………….. 

    <div id="Grid"></div> 

    <script type="text/javascript"> 

        $(function () { 

……………………… 

            $("#Grid").ejGrid({ 

……………………………….. 

                allowFiltering: true, 

                filterSettings: { filterType: "excel" }, 

                columns: [ 

…………………………………………….. 

                ] 

            }); 

        }); 

 

        function Filter() { 

            var gridObj = $("#Grid").ejGrid("instance"); // create the grid instance using grid ID. 

            gridObj.filterColumn([ 

                { field: "CustomerID", operator: "contains", value: 'o', predicate: "and", matchcase: false }, 

                { field: "CustomerID", operator: "contains", value: 'u', predicate: "and", matchcase: false }, 

            ]) 

        } 

………………………….. 

    </script> 

</body> 

</html> 

Refer the below link for sample. 

https://jsplayground.syncfusion.com/qn0f3sqv 

Regards, 

Manivannan Padmanaban. 

[Matthew]

Thank you, the code helped clarify the method. Also the problem was that during initializing my grid I had

filterSettings: { filterType: "menu" }

when what was required was,

filterSettings: { filterType: "excel" }

[Manivannan Padmanaban]

Hi Matthew, 

Thanks for the update. 

You can use the same solution for the filter type menu as well. Excel filter is work based on “and” predicate where else menu is work based on “or” predicate. For example, in the shared example we have filtered the CustomerID column which contains the value as “o” and “u”. In excel filter, due to “and” operation is shows the result as the value which contains both “o” and “u”. But the menu filter, due to “or” operation first it filter the values which contains “o” and later it filter the value which contains “u” which is the default behavior.  

Kindly get back to us, if you need further assistance. 

Regards, 

Manivannan Padmanaban. 

[Matthew]

Thank you for clearing that up Manivannan, and for your assistance.

[Manivannan Padmanaban]

Hi Matthew, 

Thanks for the update. 

Kindly get back to us, if you need further assistance. 

Regards, 

Manivannan Padmanaban.