Multiple filters on one column

Matthew

Asked On July 11, 2019 06:39 PM UTC

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".

Reply | Reply with quote

Manivannan Padmanaban [Syncfusion]

Replied On July 12, 2019 11:09 AM UTC

Hi Matthew,

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

Click here to filter

</button>

…………………..

$(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.

Reply | Reply with quote

Matthew

Replied On July 12, 2019 06:13 PM UTC

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" }

Reply | Reply with quote

Manivannan Padmanaban [Syncfusion]

Replied On July 15, 2019 08:53 AM UTC

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.

Reply | Reply with quote

Matthew

Replied On July 15, 2019 02:09 PM UTC

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

Reply | Reply with quote

Manivannan Padmanaban [Syncfusion]

Replied On July 16, 2019 04:06 AM UTC

Hi Matthew,

Thanks for the update.

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

Regards,

Manivannan Padmanaban.

Reply | Reply with quote

Thread ID:	Created:	Updated:	Platform:	Replies:
145877	Jul 11,2019 06:39 PM UTC	Jul 16,2019 04:06 AM UTC	jQuery	5

Thread ID:

Created:

Updated:

Platform:

Replies:

Please sign in to access our forum

CONTACT US