how to set two filters of the same column programmatically

Thread ID:	Created:	Updated:	Platform:	Replies:
143152	Mar 6,2019 03:50 PM UTC	Mar 7,2019 04:39 AM UTC	jQuery	1

Subscribe to this post

Tags: ejGrid

Luis Carlos

Asked On March 6, 2019 03:50 PM UTC

Good evening.

I would like to set two filters of the same column programmatically. I could use the "filterColumn" method.

This method works properly when there are two filters of different columns. However, if there are two filters of the same column, it only gets the last filter.

I will be waiting for your reply, thank you in advance.

Regards, Luis Carlos.

Reply | Reply with quote

Vignesh Natarajan [Syncfusion]

Replied On March 7, 2019 04:39 AM UTC

Hi Luis,

Thanks for contacting Syncfusion support.

Query: “I would like to set two filters of the same column programmatically”

From your query, we understand that you need to filter the same column with two values. We suggest you to achieve your requirement using filterSettings API and refreshContent() method of ejGrid. Refer the below code example

<ej-grid id="FlatGrid" allow-paging="true" datasource="ViewBag.dataSource" allow-filtering="true">

<e-filter-settings filter-type="Excel" />

<e-columns>

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

</e-columns>

</ej-grid>

function onClick() { // external button click event

var Obj = $("#FlatGrid").ejGrid("instance");

Obj.model.filterSettings.filteredColumns.push({ field: "ShipCity", operator: "startswith", value: "Be", predicate: "or", matchCase: true });

Obj.model.filterSettings.filteredColumns.push({ field: "ShipCity", operator: "startswith", value: "Ts", predicate: "or", matchCase: true });

Obj.refreshContent();

}

</script>

Refer our API documentation for your reference

https://help.syncfusion.com/api/js/ejgrid#members:filtersettings-filteredcolumns

https://help.syncfusion.com/api/js/ejgrid#methods:refreshcontent

Please get back to us if you have further queries.

Regards,

Vignesh Natarajan.

Reply | Reply with quote

CONTACT US

how to set two filters of the same column programmatically

Thread ID:

Created:

Updated:

Platform:

Replies:

Please sign in to access our forum

CONTACT US