<template>
<div>
<DxFilterBuilder
:fields="fields"
:value="filter"
:group-operations="groupOperations"
@initialized="updateTexts"
@value-changed="updateTexts"
>
<DxCustomOperation
:calculate-filter-expression="calculateFilterExpression"
name="anyof"
caption="Is any of"
icon="check"
editor-template="editorComponentTemplate"
/>
<template #editorComponentTemplate="{ data: conditionInfo }">
<EditorComponent :condition-info="conditionInfo"/>
</template>
</DxFilterBuilder>
<div class="results">
<div>
<b>Value</b>
<pre>{{ filterText }}</pre>
</div>
<div>
<b>DataSource's filter expression</b>
<pre>{{ dataSourceText }}</pre>
</div>
</div>
</div>
</template>
<script>
import DxFilterBuilder, { DxCustomOperation } from 'devextreme-vue/filter-builder';
import { filter, fields } from './data.js';
import { formatValue } from './helpers.js';
import EditorComponent from './EditorComponent.vue';
export default {
components: {
DxFilterBuilder,
DxCustomOperation,
EditorComponent
},
data() {
return {
fields,
filter,
filterText: '',
groupOperations: ['and', 'or'],
dataSourceText: ''
};
},
methods: {
updateTexts(e) {
this.filterText = formatValue(e.component.option('value'));
this.dataSourceText = formatValue(e.component.getFilterExpression());
},
calculateFilterExpression(filterValue, field) {
return filterValue && filterValue.length
&& Array.prototype.concat.apply([], filterValue.map(function(value) {
return [[field.dataField, '=', value], 'or'];
})).slice(0, -1);
}
}
};
</script>
<style scoped>
.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;
}
</style>
<template>
<DxTagBox
:value="conditionInfo.value"
:items="categories"
width="auto"
@value-changed="onValueChanged"
/>
</template>
<script>
import DxTagBox from 'devextreme-vue/tag-box';
import { categories } from './data.js';
export default {
components: {
DxTagBox
},
props: {
conditionInfo: {
type: Object,
default: () => {}
}
},
data() {
return {
categories
};
},
methods: {
onValueChanged(e) {
this.conditionInfo.setValue(e.value && e.value.length ? e.value : null);
}
}
};
</script>
export 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(' ')}`;
}
import { createApp } from 'vue';
import App from './App.vue';
createApp(App).mount('#app');
<!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" />
<link rel="stylesheet" type="text/css" href="https://cdn3.devexpress.com/jslib/20.2.4/css/dx.common.css" />
<link rel="stylesheet" type="text/css" href="https://cdn3.devexpress.com/jslib/20.2.4/css/dx.light.css" />
<script src="https://unpkg.com/core-js@2.4.1/client/shim.min.js"></script>
<script src="https://unpkg.com/systemjs@0.21.3/dist/system.js"></script>
<script type="text/javascript" src="config.js"></script>
<script type="text/javascript">
System.import('./index.js');
</script>
</head>
<body class="dx-viewport">
<div class="demo-container">
<div id="app">
</div>
</div>
</body>
</html>
export const filter = [
['Category', 'anyof', ['Automation', 'Monitors']],
'or',
[
['Category', '=', 'Televisions'],
'and',
['Price', 'between', [2000, 4000]]
]
];
export const categories = [
'Video Players',
'Televisions',
'Monitors',
'Projectors',
'Automation'
];
export const fields = [{
dataField: 'Name'
}, {
dataField: 'Price',
dataType: 'number',
format: 'currency'
}, {
dataField: 'Current_Inventory',
dataType: 'number',
caption: 'Inventory'
}, {
dataField: 'Category',
filterOperations: ['=', 'anyof'],
lookup: {
dataSource: categories
}
}];
System.config({
transpiler: 'plugin-babel',
meta: {
'*.vue': {
loader: 'vue-loader'
},
},
paths: {
'npm:': 'https://unpkg.com/'
},
map: {
'vue': 'npm:vue@3.0.0/dist/vue.esm-browser.js',
'vue-loader': 'npm:dx-systemjs-vue-browser@1.0.15/index.js',
'mitt': 'npm:mitt/dist/mitt.umd.js',
'rrule': 'npm:rrule@2.6.6/dist/es5/rrule.js',
'luxon': 'npm:luxon@1.25.0/build/global/luxon.min.js',
'es6-object-assign': 'npm:es6-object-assign@1.1.0',
'devextreme': 'npm:devextreme@20.2.4',
'devextreme-vue': 'npm:devextreme-vue@20.2.4',
'jszip': 'npm:jszip@3.5.0/dist/jszip.min.js',
'devextreme-quill': 'npm:devextreme-quill@0.9.7/dist/dx-quill.min.js',
'devexpress-diagram': 'npm:devexpress-diagram@2.0.5/dist/dx-diagram.js',
'devexpress-gantt': 'npm:devexpress-gantt@2.0.8/dist/dx-gantt.js',
'preact': 'npm:preact@10.5.7/dist/preact.js',
'preact/hooks': 'npm:preact@10.5.7/hooks/dist/hooks.js',
'plugin-babel': 'npm:systemjs-plugin-babel@0.0.25/plugin-babel.js',
'systemjs-babel-build': 'npm:systemjs-plugin-babel@0.0.25/systemjs-babel-browser.js'
},
packages: {
'devextreme-vue': {
main: 'index.js'
},
'devextreme': {
defaultExtension: 'js'
},
'devextreme/events/utils': {
main: 'index'
},
'devextreme/events': {
main: 'index'
},
'es6-object-assign': {
main: './index.js',
defaultExtension: 'js'
}
},
babelOptions: {
sourceMaps: false,
stage0: true
}
});