$(function() {
$("#filterBuilder").dxFilterBuilder({
fields: fields,
value: filter,
maxGroupLevel: 1,
groupOperations: ["and", "or"],
onValueChanged: updateTexts,
onInitialized: updateTexts,
customOperations: [{
name: "anyof",
caption: "Is any of",
icon: "check",
editorTemplate: function(conditionInfo) {
return $("<div>").dxTagBox({
value: conditionInfo.value,
items: categories,
onValueChanged: function(e) {
conditionInfo.setValue(e.value && e.value.length ? e.value : null);
},
width: "auto"
});
},
calculateFilterExpression: function(filterValue, field) {
return filterValue && filterValue.length
&& Array.prototype.concat.apply([], filterValue.map(function(value) {
return [[field.dataField, "=", value], "or"];
})).slice(0, -1);
}
}]
});
function updateTexts(e) {
$("#filterText").text(formatValue(e.component.option("value")));
$("#dataSourceText").text(formatValue(e.component.getFilterExpression()));
}
function formatValue(value, spaces) {
if(value && Array.isArray(value[0])) {
var TAB_SIZE = 4;
spaces = spaces || TAB_SIZE;
return "[" + getLineBreak(spaces) + value.map(function(item) {
return Array.isArray(item[0]) ? formatValue(item, spaces + TAB_SIZE) : JSON.stringify(item);
}).join("," + getLineBreak(spaces)) + getLineBreak(spaces - TAB_SIZE) + "]";
}
return JSON.stringify(value);
}
function getLineBreak(spaces) {
return "\r\n" + new Array(spaces + 1).join(" ");
}
});
<!DOCTYPE html>
<html>
<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/cldrjs/0.4.4/cldr.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/cldrjs/0.4.4/cldr/event.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/cldrjs/0.4.4/cldr/supplemental.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/cldrjs/0.4.4/cldr/unresolved.min.js"></script>
<link rel="stylesheet" type="text/css" href="https://cdn3.devexpress.com/jslib/20.2.5/css/dx.common.css" />
<link rel="stylesheet" type="text/css" href="https://cdn3.devexpress.com/jslib/20.2.5/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/20.2.5/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 id="filterBuilder"></div>
<div class="results">
<div>
<b>Value</b>
<pre id="filterText"></pre>
</div>
<div>
<b>DataSource's filter expression</b>
<pre id="dataSourceText"></pre>
</div>
</div>
</div>
</body>
</html>
.results {
margin-top: 50px;
display: flex;
justify-content: space-between;
}
.results > div {
flex-basis: 49%;
max-width: 50%;
background-color: rgba(191, 191, 191, 0.15);
position: relative;
}
.results b {
position: absolute;
top: -25px;
}
.results pre {
padding: 10px 20px;
height: 100%;
font-size: 13px;
overflow: auto;
box-sizing: border-box;
}
.dx-tagbox {
min-width: 150px;
}
.dx-filterbuilder .dx-numberbox {
width: 80px;
}
var filter = [
["Category", "anyof", ["Automation", "Monitors"]],
"or",
[
["Category", "=", "Televisions"],
"and",
["Price", "between", [2000, 4000]]
]
],
categories = [
"Video Players",
"Televisions",
"Monitors",
"Projectors",
"Automation"
],
fields = [{
dataField: "Name"
}, {
dataField: "Price",
dataType: "number",
format: "currency"
}, {
dataField: "Current_Inventory",
dataType: "number",
caption: "Inventory"
}, {
dataField: "Category",
filterOperations: ["=", "anyof"],
lookup: {
dataSource: categories
}
}
];