Filtering
Documentation
This example demonstrates the DataGrid’s built-in filtering and searching capabilities. The filter row, located under the column headers, allows a user to type any value and select filter operations. With the header filter, which is called by clicking the filter icon in any column header, a user can choose from a set of predefined values. The search panel at the top of the DataGrid allows searching for values in all columns at once.
Thank you!
We appreciate your feedback.
We appreciate your feedback.
var DemoApp = angular.module('DemoApp', ['dx']);
DemoApp.controller('DemoController', function DemoController($scope) {
var applyFilterTypes = [{
key: "auto",
name: "Immediately"
}, {
key: "onClick",
name: "On Button Click"
}],
dataGrid;
function getOrderDay(rowData) {
return (new Date(rowData.OrderDate)).getDay();
}
$scope.filterRow = {
visible: true,
applyFilter: "auto"
};
$scope.headerFilter = {
visible: true
};
$scope.gridOptions = {
onInitialized: function(e) {
dataGrid = e.component;
},
dataSource: orders,
showBorders: true,
bindingOptions: {
filterRow: "filterRow",
headerFilter: "headerFilter"
},
searchPanel: {
visible: true,
width: 240,
placeholder: "Search..."
},
columns: [{
dataField: "OrderNumber",
width: 140,
caption: "Invoice Number",
headerFilter: {
groupInterval: 10000
}
}, {
dataField: "OrderDate",
alignment: "right",
dataType: "date",
width: 120,
calculateFilterExpression: function(value, selectedFilterOperations, target) {
if(target === "headerFilter" && value === "weekends") {
return [[getOrderDay, "=", 0], "or", [getOrderDay, "=", 6]];
}
return this.defaultCalculateFilterExpression.apply(this, arguments);
},
headerFilter: {
dataSource: function(data) {
data.dataSource.postProcess = function(results) {
results.push({
text: "Weekends",
value: "weekends"
});
return results;
};
}
}
}, {
dataField: "DeliveryDate",
alignment: "right",
dataType: "datetime",
width: 180,
format: "M/d/yyyy, HH:mm"
}, {
dataField: "SaleAmount",
alignment: "right",
format: "currency",
editorOptions: {
format: "currency",
showClearButton: true
},
headerFilter: {
dataSource: [ {
text: "Less than $3000",
value: ["SaleAmount", "<", 3000]
}, {
text: "$3000 - $5000",
value: [["SaleAmount", ">=", 3000], ["SaleAmount", "<", 5000]]
}, {
text: "$5000 - $10000",
value: [["SaleAmount", ">=", 5000], ["SaleAmount", "<", 10000]]
}, {
text: "$10000 - $20000",
value: [["SaleAmount", ">=", 10000], ["SaleAmount", "<", 20000]]
}, {
text: "Greater than $20000",
value: ["SaleAmount", ">=", 20000]
}]
}
}, "Employee", {
caption: "City",
dataField: "CustomerStoreCity",
headerFilter: {
allowSearch: true
}
}]
};
$scope.filterTypesOptions = {
items: applyFilterTypes,
value: applyFilterTypes[0].key,
valueExpr: "key",
displayExpr: "name",
bindingOptions: {
value: "filterRow.applyFilter",
disabled: "!filterRow.visible"
}
};
$scope.filterVisibleOptions = {
text: "Filter Row",
bindingOptions: {
value: "filterRow.visible"
},
onValueChanged: function(data) {
dataGrid.clearFilter();
}
};
$scope.headerFilterOptions = {
text: "Header Filter",
bindingOptions: {
value: "headerFilter.visible"
},
onValueChanged: function() {
dataGrid.clearFilter();
}
};
});
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml" >
<head>
<title>DevExtreme Demo</title>
<meta http-equiv="X-UA-Compatible" content="IE=edge" />
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<meta name="viewport" content="width=device-width, initial-scale=1.0, maximum-scale=1.0" />
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.1.0/jquery.min.js"></script>
<script>window.jQuery || document.write(decodeURIComponent('%3Cscript src="js/jquery.min.js"%3E%3C/script%3E'))</script>
<link rel="stylesheet" type="text/css" href="https://cdn3.devexpress.com/jslib/19.1.3/css/dx.common.css" />
<link rel="dx-theme" data-theme="generic.light" href="https://cdn3.devexpress.com/jslib/19.1.3/css/dx.light.css" />
<script src="https://ajax.googleapis.com/ajax/libs/angularjs/1.3.16/angular.min.js"></script>
<script>window.angular || document.write(decodeURIComponent('%3Cscript src="js/angular.min.js"%3E%3C\/script%3E'))</script>
<script src="https://cdn3.devexpress.com/jslib/19.1.3/js/dx.all.js"></script>
<script src="data.js"></script>
<link rel="stylesheet" type ="text/css" href ="styles.css" />
<script src="index.js"></script>
</head>
<body class="dx-viewport">
<div class="demo-container" ng-app="DemoApp" ng-controller="DemoController">
<div id="gridContainer" dx-data-grid="gridOptions"></div>
<div class="options">
<div class="caption">Options</div>
<div class="option">
<span>Apply Filter</span>
<div id="useFilterApplyButton" dx-select-box="filterTypesOptions"></div>
</div>
<div class="option">
<div dx-check-box="filterVisibleOptions"></div>
</div>
<div class="option">
<div dx-check-box="headerFilterOptions"></div>
</div>
</div>
</div>
</body>
</html>
#gridContainer {
height: 440px;
}
.options {
padding: 20px;
margin-top: 20px;
background-color: rgba(191, 191, 191, 0.15);
}
.caption {
font-size: 18px;
font-weight: 500;
}
.option {
margin-top: 10px;
}
.option > span {
margin-right: 10px;
}
.option > .dx-selectbox {
display: inline-block;
vertical-align: middle;
}
var orders = [{
"ID": 1,
"OrderNumber": 35703,
"OrderDate": "2017/04/10",
"DeliveryDate": "2017/04/13 9:00",
"SaleAmount": 11800,
"Terms": "15 Days",
"CustomerStoreCity": "Los Angeles, CA",
"Employee": "Harv Mudd"
}, {
"ID": 4,
"OrderNumber": 35711,
"OrderDate": "2017/01/12",
"DeliveryDate": "2017/01/13 9:00",
"SaleAmount": 16050,
"Terms": "15 Days",
"CustomerStoreCity": "San Jose, CA",
"Employee": "Jim Packard"
}, {
"ID": 5,
"OrderNumber": 35714,
"OrderDate": "2017/01/22",
"DeliveryDate": "2017/01/27 9:00",
"SaleAmount": 14750,
"Terms": "15 Days",
"CustomerStoreCity": "Las Vegas, NV",
"Employee": "Harv Mudd"
}, {
"ID": 7,
"OrderNumber": 35983,
"OrderDate": "2017/02/07",
"DeliveryDate": "2017/02/10 13:00",
"SaleAmount": 3725,
"Terms": "15 Days",
"CustomerStoreCity": "Denver, CO",
"Employee": "Todd Hoffman"
}, {
"ID": 11,
"OrderNumber": 38466,
"OrderDate": "2017/03/01",
"DeliveryDate": "2017/03/03 17:45",
"SaleAmount": 7800,
"Terms": "15 Days",
"CustomerStoreCity": "Los Angeles, CA",
"Employee": "Harv Mudd"
}, {
"ID": 14,
"OrderNumber": 39420,
"OrderDate": "2017/02/15",
"DeliveryDate": "2017/02/17 11:45",
"SaleAmount": 20500,
"Terms": "15 Days",
"CustomerStoreCity": "San Jose, CA",
"Employee": "Jim Packard"
}, {
"ID": 15,
"OrderNumber": 39874,
"OrderDate": "2017/02/04",
"DeliveryDate": "2017/02/10 15:00",
"SaleAmount": 9050,
"Terms": "30 Days",
"CustomerStoreCity": "Las Vegas, NV",
"Employee": "Harv Mudd"
}, {
"ID": 18,
"OrderNumber": 42847,
"OrderDate": "2017/02/15",
"DeliveryDate": "2017/02/17 8:30",
"SaleAmount": 20400,
"Terms": "30 Days",
"CustomerStoreCity": "Casper, WY",
"Employee": "Todd Hoffman"
}, {
"ID": 30,
"OrderNumber": 57429,
"OrderDate": "2017/05/16",
"DeliveryDate": "2017/05/19 11:45",
"SaleAmount": 11050,
"Terms": "30 Days",
"CustomerStoreCity": "Phoenix, AZ",
"Employee": "Clark Morgan"
}, {
"ID": 32,
"OrderNumber": 58292,
"OrderDate": "2017/05/13",
"DeliveryDate": "2017/05/19 14:30",
"SaleAmount": 13500,
"Terms": "15 Days",
"CustomerStoreCity": "Los Angeles, CA",
"Employee": "Harv Mudd"
}, {
"ID": 36,
"OrderNumber": 62427,
"OrderDate": "2017/01/27",
"DeliveryDate": "2017/02/03 18:00",
"SaleAmount": 23500,
"Terms": "15 Days",
"CustomerStoreCity": "Las Vegas, NV",
"Employee": "Harv Mudd"
}, {
"ID": 39,
"OrderNumber": 65977,
"OrderDate": "2017/02/05",
"DeliveryDate": "2017/02/10 13:15",
"SaleAmount": 2550,
"Terms": "15 Days",
"CustomerStoreCity": "Casper, WY",
"Employee": "Todd Hoffman"
}, {
"ID": 42,
"OrderNumber": 68428,
"OrderDate": "2017/04/10",
"DeliveryDate": "2017/04/14 11:30",
"SaleAmount": 10500,
"Terms": "15 Days",
"CustomerStoreCity": "Los Angeles, CA",
"Employee": "Harv Mudd"
}, {
"ID": 43,
"OrderNumber": 69477,
"OrderDate": "2017/03/09",
"DeliveryDate": "2017/03/10 12:00",
"SaleAmount": 14200,
"Terms": "15 Days",
"CustomerStoreCity": "Anaheim, CA",
"Employee": "Harv Mudd"
}, {
"ID": 46,
"OrderNumber": 72947,
"OrderDate": "2017/01/14",
"DeliveryDate": "2017/01/20 9:00",
"SaleAmount": 13350,
"Terms": "30 Days",
"CustomerStoreCity": "Las Vegas, NV",
"Employee": "Harv Mudd"
}, {
"ID": 47,
"OrderNumber": 73088,
"OrderDate": "2017/03/25",
"DeliveryDate": "2017/03/31 17:15",
"SaleAmount": 8600,
"Terms": "30 Days",
"CustomerStoreCity": "Reno, NV",
"Employee": "Clark Morgan"
}, {
"ID": 51,
"OrderNumber": 77297,
"OrderDate": "2017/04/30",
"DeliveryDate": "2017/05/05 18:00",
"SaleAmount": 10850,
"Terms": "30 Days",
"CustomerStoreCity": "Phoenix, AZ",
"Employee": "Clark Morgan"
}, {
"ID": 56,
"OrderNumber": 84744,
"OrderDate": "2017/02/10",
"DeliveryDate": "2017/02/17 14:00",
"SaleAmount": 4650,
"Terms": "30 Days",
"CustomerStoreCity": "Las Vegas, NV",
"Employee": "Harv Mudd"
}, {
"ID": 57,
"OrderNumber": 85028,
"OrderDate": "2017/05/17",
"DeliveryDate": "2017/05/19 12:00",
"SaleAmount": 2575,
"Terms": "30 Days",
"CustomerStoreCity": "Reno, NV",
"Employee": "Clark Morgan"
}, {
"ID": 59,
"OrderNumber": 87297,
"OrderDate": "2017/04/21",
"DeliveryDate": "2017/04/28 9:00",
"SaleAmount": 14200,
"Terms": "30 Days",
"CustomerStoreCity": "Casper, WY",
"Employee": "Todd Hoffman"
}, {
"ID": 65,
"OrderNumber": 94726,
"OrderDate": "2017/05/22",
"DeliveryDate": "2017/05/26 13:30",
"SaleAmount": 20500,
"Terms": "15 Days",
"CustomerStoreCity": "San Jose, CA",
"Employee": "Jim Packard"
}, {
"ID": 66,
"OrderNumber": 95266,
"OrderDate": "2017/03/10",
"DeliveryDate": "2017/03/17 11:45",
"SaleAmount": 9050,
"Terms": "15 Days",
"CustomerStoreCity": "Las Vegas, NV",
"Employee": "Harv Mudd"
}, {
"ID": 69,
"OrderNumber": 98477,
"OrderDate": "2017/01/01",
"DeliveryDate": "2017/01/06 9:00",
"SaleAmount": 23500,
"Terms": "15 Days",
"CustomerStoreCity": "Casper, WY",
"Employee": "Todd Hoffman"
}, {
"ID": 78,
"OrderNumber": 174884,
"OrderDate": "2017/04/10",
"DeliveryDate": "2017/04/14 8:30",
"SaleAmount": 7200,
"Terms": "30 Days",
"CustomerStoreCity": "Denver, CO",
"Employee": "Todd Hoffman"
}, {
"ID": 81,
"OrderNumber": 188877,
"OrderDate": "2017/02/11",
"DeliveryDate": "2017/02/17 16:00",
"SaleAmount": 8750,
"Terms": "30 Days",
"CustomerStoreCity": "Phoenix, AZ",
"Employee": "Clark Morgan"
}, {
"ID": 82,
"OrderNumber": 191883,
"OrderDate": "2017/02/05",
"DeliveryDate": "2017/02/10 18:30",
"SaleAmount": 9900,
"Terms": "30 Days",
"CustomerStoreCity": "Los Angeles, CA",
"Employee": "Harv Mudd"
}, {
"ID": 83,
"OrderNumber": 192474,
"OrderDate": "2017/01/21",
"DeliveryDate": "2017/01/27 12:45",
"SaleAmount": 12800,
"Terms": "30 Days",
"CustomerStoreCity": "Anaheim, CA",
"Employee": "Harv Mudd"
}, {
"ID": 84,
"OrderNumber": 193847,
"OrderDate": "2017/03/21",
"DeliveryDate": "2017/03/24 9:00",
"SaleAmount": 14100,
"Terms": "30 Days",
"CustomerStoreCity": "San Diego, CA",
"Employee": "Harv Mudd"
}, {
"ID": 85,
"OrderNumber": 194877,
"OrderDate": "2017/03/06",
"DeliveryDate": "2017/03/10 18:15",
"SaleAmount": 4750,
"Terms": "30 Days",
"CustomerStoreCity": "San Jose, CA",
"Employee": "Jim Packard"
}, {
"ID": 86,
"OrderNumber": 195746,
"OrderDate": "2017/05/26",
"DeliveryDate": "2017/06/02 17:00",
"SaleAmount": 9050,
"Terms": "30 Days",
"CustomerStoreCity": "Las Vegas, NV",
"Employee": "Harv Mudd"
}, {
"ID": 87,
"OrderNumber": 197474,
"OrderDate": "2017/03/02",
"DeliveryDate": "2017/03/03 11:00",
"SaleAmount": 6400,
"Terms": "30 Days",
"CustomerStoreCity": "Reno, NV",
"Employee": "Clark Morgan"
}, {
"ID": 88,
"OrderNumber": 198746,
"OrderDate": "2017/05/09",
"DeliveryDate": "2017/05/12 15:45",
"SaleAmount": 15700,
"Terms": "30 Days",
"CustomerStoreCity": "Denver, CO",
"Employee": "Todd Hoffman"
}, {
"ID": 91,
"OrderNumber": 214222,
"OrderDate": "2017/02/08",
"DeliveryDate": "2017/02/10 9:45",
"SaleAmount": 11050,
"Terms": "30 Days",
"CustomerStoreCity": "Phoenix, AZ",
"Employee": "Clark Morgan"
}];