window.onload = function () {
const filterBuilderValue = ko.observable(filter);
const dataGridFilter = ko.observable(filter);
const viewModel = {
filterBuilderOptions: {
fields,
value: filterBuilderValue,
},
buttonOptions: {
text: 'Apply Filter',
type: 'default',
onClick() {
dataGridFilter(filterBuilderValue());
},
},
dataGridOptions: {
columns: fields,
showBorders: true,
dataSource: {
store: {
type: 'odata',
fieldTypes: {
Product_Cost: 'Decimal',
Product_Sale_Price: 'Decimal',
Product_Retail_Price: 'Decimal',
},
url: 'https://js.devexpress.com/Demos/DevAV/odata/Products',
},
select: [
'Product_ID',
'Product_Name',
'Product_Cost',
'Product_Sale_Price',
'Product_Retail_Price',
'Product_Current_Inventory',
],
},
filterValue: dataGridFilter,
height: 300,
},
};
ko.applyBindings(viewModel, document.getElementById('demo'));
};
<!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.5.1/jquery.min.js"></script>
<script>window.jQuery || document.write(decodeURIComponent('%3Cscript src="js/jquery.min.js"%3E%3C/script%3E'))</script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/knockout/3.4.2/knockout-min.js"></script>
<link rel="stylesheet" type="text/css" href="https://cdn3.devexpress.com/jslib/22.2.3/css/dx.light.css" />
<link rel="stylesheet" type="text/css" href="https://maxcdn.bootstrapcdn.com/font-awesome/4.6.3/css/font-awesome.min.css">
<script src="https://cdn3.devexpress.com/jslib/22.2.3/js/dx.all.js"></script>
<link rel="stylesheet" type="text/css" href="styles.css" />
<script src="data.js"></script>
<script src="index.js"></script>
</head>
<body class="dx-viewport">
<div class="demo-container">
<div class="filter-container">
<div data-bind="dxFilterBuilder: filterBuilderOptions"></div>
<div data-bind="dxButton: buttonOptions"></div>
<div class="dx-clearfix"></div>
</div>
<div data-bind="dxDataGrid: dataGridOptions"></div>
</div>
</body>
</html>
.filter-container {
background-color: rgba(191, 191, 191, 0.15);
padding: 5px;
width: 500px;
margin-bottom: 25px;
}
.dx-filterbuilder {
padding: 10px;
}
.dx-button {
margin: 10px;
float: right;
}
.dx-filterbuilder .dx-numberbox {
width: 80px;
}
const filter = [
['Product_Current_Inventory', '<>', 0],
'or',
[
['Product_Name', 'contains', 'HD'],
'and',
['Product_Cost', '<', 200],
],
];
const fields = [
{
caption: 'ID',
width: 50,
dataField: 'Product_ID',
dataType: 'number',
}, {
dataField: 'Product_Name',
dataType: 'string',
}, {
caption: 'Cost',
dataField: 'Product_Cost',
dataType: 'number',
format: 'currency',
}, {
dataField: 'Product_Sale_Price',
caption: 'Sale Price',
dataType: 'number',
format: 'currency',
}, {
dataField: 'Product_Retail_Price',
caption: 'Retail Price',
dataType: 'number',
format: 'currency',
}, {
dataField: 'Product_Current_Inventory',
dataType: 'number',
caption: 'Inventory',
},
];