igGrid - filtering does not contain
by georgianastasov
HTML
<script src="https://igniteui.com/js/modernizr.min.js"></script>
<script src="https://code.jquery.com/jquery-1.9.1.min.js"></script>
<script src="https://code.jquery.com/ui/1.10.3/jquery-ui.min.js"></script>
<script src="https://cdn-na.infragistics.com/igniteui/latest/js/infragistics.core.js"></script>
<script src="https://cdn-na.infragistics.com/igniteui/latest/js/infragistics.lob.js"></script>
<script src="https://igniteui.com/js-data/employee-data-allDatatypes"></script>
<link href="https://cdn-na.infragistics.com/igniteui/latest/css/themes/infragistics/infragistics.theme.css" rel="stylesheet"></link>
<link href="https://cdn-na.infragistics.com/igniteui/latest/css/structure/infragistics.css" rel="stylesheet"></link>
<table id="grid"></table>
JavaScript
$(function () {
//Here we have a simple date with one field with NULL value
var data = [
{ FirstName: 'Jon', LastName: 'Smith', RegistererDate: '11/11/2022', Country: 'USA', Age: 20, IsActive: true},
{ FirstName: 'Bob', LastName: undefined, RegistererDate: '10/10/2022', Country: 'USA', Age: 21, IsActive: false},
{ FirstName: 'Jake', LastName: 'Sollins', RegistererDate: '12/12/2022', Country: 'USA', Age: 22, IsActive: true},
{ FirstName: 'Simon', LastName: 'Sins', RegistererDate: '1/1/2022', Country: 'USA', Age: 23, IsActive: true},
{ FirstName: 'Kevin', LastName: 'Sake', RegistererDate: '8/8/2022', Country: 'USA', Age: 24, IsActive: false}
];
$("#grid").igGrid({
autoGenerateColumns: false,
height: "500px",
width: "100%",
columns: [
{ headerText: "First Name", key: "FirstName", dataType: "string", width: "110px" },
{ headerText: "Last Name", key: "LastName", dataType: "string", width: "110px" },
{ headerText: "Register Date", key: "RegistererDate", dataType: "date", width: "150px" },
{ headerText: "Country", key: "Country", dataType: "string" },
{ headerText: "Age", key: "Age", dataType: "number" },
{ headerText: "Is Active", key: "IsActive", dataType: "bool" }
],
dataSource: data,
//Here is the fauture iniciallization of Filtering
features: [
{
name: "Filtering",
type: "local",
mode: "simple",
//case sensitive
caseSensitive : false,
//show empty condition in filter
showEmptyConditions : true,
//show null condition in filter
showNullConditions : true,
columnSettings : [
{
columnKey: "LastName",
condition: "doesNotContain"
}
],
//data filtered event
...