Hi Sandeep,
Greetings from Syncfusion support.
By analyzing your query, we suspect that you want to perform filtering with “contains” operator for DocumentNumber column. Before proceeding your requirement, We would like to share the behavior of filter operators in EJ2 Grid.
By default, the “startswith” operator is applied to filter a string type column and “equal” operator is applied to filter a number type column in the Grid.
You have the option to change the default filter operator for particular column by using filter property of Column Model. Refer to the below code example.
<template>
<div id="app">
<ejs-grid
ref="grid1"
:dataSource="data"
:allowPaging="true"
:allowFiltering="true"
:filterSettings="filterOptions"
:dataBound="dataBound"
>
<e-columns>
----
<e-column
field="DocumentNumber"
headerText="DocumentNumber"
width="180"
headerTextAlign="center"
:filter="filterOptions"
></e-column>
----
</e-columns>
</ejs-grid>
</div>
</template>
<script>
--
export default {
data() {
return {
---
filterOptions: { operator: "contains"},
};
},
---
};
</script>
|
If you want to change the default filter operator for all the string type column, use below code in the dataBound event of Grid.
dataBound: function (args) {
var gridObj = this.$refs.grid1.$el.ej2_instances[0];
Object.assign(gridObj.filterModule.filterOperators, {
startsWith: "contains", // change the default operator as contains for string type column
});
},
|
Please get back to us if you need further assistance with this.
Regards,
Rajapandiyan S
