Backend API
import React, { useCallback, useState } from 'react';
import FilterBuilder, { CustomOperation } from 'devextreme-react/filter-builder';
import type { FilterBuilderTypes, ICustomOperationProps } from 'devextreme-react/filter-builder';
import { filter, fields, groupOperations } from './data.ts';
import { formatValue } from './helpers.ts';
import { EditorComponent } from './EditorComponent.tsx';
function App() {
const [value, setValue] = useState(filter);
const [filterText, setFilterText] = useState('');
const [dataSourceText, setDataSourceText] = useState('');
const updateTexts = useCallback((e: FilterBuilderTypes.InitializedEvent) => {
setFilterText(formatValue(e.component?.option('value')));
setDataSourceText(formatValue(e.component?.getFilterExpression()));
}, []);
const onValueChanged = useCallback((e: FilterBuilderTypes.ValueChangedEvent) => {
setValue(e.value);
updateTexts(e);
}, [updateTexts]);
const calculateFilterExpression: ICustomOperationProps['calculateFilterExpression'] = useCallback((filterValue, field) => (
filterValue?.length
&& Array.prototype.concat
.apply(
[],
filterValue.map((i: string) => [[field.dataField, '=', i], 'or']),
)
.slice(0, -1)
), []);
return (
<div>
<FilterBuilder
fields={fields}
value={value}
onInitialized={updateTexts}
groupOperations={groupOperations}
onValueChanged={onValueChanged}
>
<CustomOperation
name="anyof"
caption="Is any of"
icon="check"
editorComponent={EditorComponent}
calculateFilterExpression={calculateFilterExpression}
/>
</FilterBuilder>
<div className="results">
<div>
<b>Value</b>
<pre>{filterText}</pre>
</div>
<div>
<b>DataSource's filter expression</b>
<pre>{dataSourceText}</pre>
</div>
</div>
</div>
);
}
export default App;
import React, { useCallback, useState } from 'react';
import FilterBuilder, { CustomOperation } from 'devextreme-react/filter-builder';
import { filter, fields, groupOperations } from './data.js';
import { formatValue } from './helpers.js';
import { EditorComponent } from './EditorComponent.js';
function App() {
const [value, setValue] = useState(filter);
const [filterText, setFilterText] = useState('');
const [dataSourceText, setDataSourceText] = useState('');
const updateTexts = useCallback((e) => {
setFilterText(formatValue(e.component?.option('value')));
setDataSourceText(formatValue(e.component?.getFilterExpression()));
}, []);
const onValueChanged = useCallback(
(e) => {
setValue(e.value);
updateTexts(e);
},
[updateTexts],
);
const calculateFilterExpression = useCallback(
(filterValue, field) =>
filterValue?.length &&
Array.prototype.concat
.apply(
[],
filterValue.map((i) => [[field.dataField, '=', i], 'or']),
)
.slice(0, -1),
[],
);
return (
<div>
<FilterBuilder
fields={fields}
value={value}
onInitialized={updateTexts}
groupOperations={groupOperations}
onValueChanged={onValueChanged}
>
<CustomOperation
name="anyof"
caption="Is any of"
icon="check"
editorComponent={EditorComponent}
calculateFilterExpression={calculateFilterExpression}
/>
</FilterBuilder>
<div className="results">
<div>
<b>Value</b>
<pre>{filterText}</pre>
</div>
<div>
<b>DataSource's filter expression</b>
<pre>{dataSourceText}</pre>
</div>
</div>
</div>
);
}
export default App;
import React, { useCallback } from 'react';
import TagBox, { type TagBoxTypes } from 'devextreme-react/tag-box';
import { categories, categoryLabel } from './data.ts';
export const EditorComponent = (props: { data: { value: any, setValue: (value: any) => void } }) => {
const onValueChanged = useCallback((e: TagBoxTypes.ValueChangedEvent) => {
props.data.setValue(e.value?.length ? e.value : null);
}, [props.data]);
return (
<TagBox
inputAttr={categoryLabel}
defaultValue={props.data.value}
items={categories}
onValueChanged={onValueChanged}
width="auto"
/>
);
};
import React from 'react';
import ReactDOM from 'react-dom';
import App from './App.tsx';
ReactDOM.render(
<App />,
document.getElementById('app'),
);
import type { FilterBuilderTypes } from 'devextreme-react/filter-builder';
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 groupOperations: FilterBuilderTypes.GroupOperation[] = ['and', 'or'];
export const fields: FilterBuilderTypes.Field[] = [{
dataField: 'Name',
}, {
dataField: 'Price',
dataType: 'number',
format: 'currency',
}, {
dataField: 'Current_Inventory',
dataType: 'number',
caption: 'Inventory',
}, {
dataField: 'Category',
filterOperations: ['=', 'anyof'],
lookup: {
dataSource: categories,
},
}];
export const categoryLabel = { 'aria-label': 'Category' };
import type { FilterBuilderTypes } from 'devextreme-react/filter-builder';
type FilterValue = FilterBuilderTypes.Properties['value'];
const TAB_SIZE = 4;
function prepareItem(item: FilterValue, spaces: number): string {
return Array.isArray(item) && Array.isArray(item[0])
? formatValue(item, spaces + TAB_SIZE)
: JSON.stringify(item);
}
export function formatValue(value: FilterValue, spaces: number = TAB_SIZE): string {
if (value && Array.isArray(value) && Array.isArray(value[0])) {
const formattedValue = value
.map((item) => prepareItem(item, spaces))
.join(`,${getLineBreak(spaces)}`);
return `[${getLineBreak(spaces)}${formattedValue}${getLineBreak(spaces - TAB_SIZE)}]`;
}
return JSON.stringify(value);
}
function getLineBreak(spaces: number) {
return `\r\n${new Array(spaces + 1).join(' ')}`;
}
import React, { useCallback } from 'react';
import TagBox from 'devextreme-react/tag-box';
import { categories, categoryLabel } from './data.js';
export const EditorComponent = (props) => {
const onValueChanged = useCallback(
(e) => {
props.data.setValue(e.value?.length ? e.value : null);
},
[props.data],
);
return (
<TagBox
inputAttr={categoryLabel}
defaultValue={props.data.value}
items={categories}
onValueChanged={onValueChanged}
width="auto"
/>
);
};
const TAB_SIZE = 4;
function prepareItem(item, spaces) {
return Array.isArray(item) && Array.isArray(item[0])
? formatValue(item, spaces + TAB_SIZE)
: JSON.stringify(item);
}
export function formatValue(value, spaces = TAB_SIZE) {
if (value && Array.isArray(value) && Array.isArray(value[0])) {
const formattedValue = value
.map((item) => prepareItem(item, spaces))
.join(`,${getLineBreak(spaces)}`);
return `[${getLineBreak(spaces)}${formattedValue}${getLineBreak(spaces - TAB_SIZE)}]`;
}
return JSON.stringify(value);
}
function getLineBreak(spaces) {
return `\r\n${new Array(spaces + 1).join(' ')}`;
}
import React from 'react';
import ReactDOM from 'react-dom';
import App from './App.js';
ReactDOM.render(<App />, document.getElementById('app'));
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 groupOperations = ['and', 'or'];
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,
},
},
];
export const categoryLabel = { 'aria-label': 'Category' };
<!DOCTYPE html>
<html lang="en">
<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=5.0" />
<link rel="stylesheet" type="text/css" href="https://cdn3.devexpress.com/jslib/26.1.5/css/dx.light.css" />
<link rel="stylesheet" type="text/css" href="./bundle.css" />
</head>
<body class="dx-viewport">
<div class="demo-container">
<div id="app"></div>
</div>
<script src="bundles/vendor/react.vendor.js"></script>
<script src="./bundle.js"></script>
</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 {
background-color: transparent;
box-shadow: 0 8px 16px 0 rgba(0, 0, 0, 0.14), 0 0 2px 0 rgba(0, 0, 0, 0.12);
border-radius: 6px;
padding: 15px;
margin: 24px;
}
.dx-filterbuilder .dx-numberbox {
width: 80px;
}