Your search did not match any results.
Filter Builder

Customization

Documentation

In this demo, a custom filter operation, "anyof", is implemented. The calculateFilterExpression function converts it into DataSource-compatible operations. The compatible and incompatible filter expressions are displayed under the FilterBuilder.

The set of available group operations is limited to "and" and "or" using the groupOperations array, and the groups’ maximum nesting level is limited to one using the maxGroupLevel.

Copy to CodeSandBox
Apply
Reset
<dx-filter-builder [fields]="fields" [(value)]="filter" [groupOperations]="groupOperations" [customOperations]="customOperations" (onInitialized)="updateTexts($event)" (onValueChanged)="updateTexts($event)"> <dx-tag-box *dxTemplate="let condition of 'tagBoxTemplate'" [value]="condition.value" [items]="categories" (onValueChanged)="condition.setValue($event.value)" width="auto"> </dx-tag-box> </dx-filter-builder> <div class="results"> <div> <b>Value</b> <pre>{{filterText}}</pre> </div> <div> <b>DataSource's filter expression</b> <pre>{{dataSourceText}}</pre> </div> </div>
import { NgModule, Component, ViewChild, enableProdMode } from '@angular/core'; import { BrowserModule } from '@angular/platform-browser'; import { platformBrowserDynamic } from '@angular/platform-browser-dynamic'; import { DxListModule, DxButtonModule, DxTagBoxModule, DxFilterBuilderModule } from 'devextreme-angular'; import { Service } from './app.service'; if(!/localhost/.test(document.location.host)) { enableProdMode(); } let anyOfOperation = { name: "anyof", caption: "Is any of", icon: "check", editorTemplate: "tagBoxTemplate", calculateFilterExpression(filterValue: any, field: any) { return filterValue && filterValue.length && Array.prototype.concat.apply([], filterValue.map(function(value) { return [[field.dataField, "=", value], "or"]; })).slice(0, -1); } }; @Component({ selector: 'demo-app', providers: [Service], templateUrl: 'app/app.component.html', styleUrls: ['app/app.component.css'] }) export class AppComponent { filterText: any; dataSourceText: any; fields: Array<any>; customOperations: Array<any>; filter: any; categories: string[]; groupOperations: string[] = ["and", "or"]; constructor(service: Service) { this.fields = service.getFields(); this.filter = service.getFilter(); this.categories = service.getCategories(); this.customOperations = [anyOfOperation]; } updateTexts(e) { this.filterText = AppComponent.formatValue(e.component.option("value")); this.dataSourceText = AppComponent.formatValue(e.component.getFilterExpression()); } private static formatValue(value, spaces = 0) { if(value && Array.isArray(value[0])) { var TAB_SIZE = 4; spaces = spaces || TAB_SIZE; return "[" + AppComponent.getLineBreak(spaces) + value.map(function(item) { return Array.isArray(item[0]) ? AppComponent.formatValue(item, spaces + TAB_SIZE) : JSON.stringify(item); }).join("," + AppComponent.getLineBreak(spaces)) + AppComponent.getLineBreak(spaces - TAB_SIZE) + "]"; } return JSON.stringify(value); } private static getLineBreak(spaces) { return "\r\n" + new Array(spaces + 1).join(" "); } } @NgModule({ imports: [ BrowserModule, DxListModule, DxButtonModule, DxTagBoxModule, DxFilterBuilderModule ], declarations: [AppComponent], bootstrap: [AppComponent] }) export class AppModule { } platformBrowserDynamic().bootstrapModule(AppModule);
::ng-deep .results { margin-top: 50px; display: flex; justify-content: space-between; } ::ng-deep .results > div { flex-basis: 49%; max-width: 50%; background-color: rgba(191, 191, 191, 0.15); position: relative; } ::ng-deep .results b { position: absolute; top: -25px; } ::ng-deep .results pre { padding: 10px 20px; height: 100%; font-size: 13px; overflow: auto; box-sizing: border-box; } ::ng-deep .dx-tagbox { min-width: 150px; } ::ng-deep .dx-filterbuilder .dx-numberbox { width: 80px; }
import { Injectable } from '@angular/core'; export class Product { ID: number; Name: string; Price: number; Current_Inventory: number; Backorder: number; Manufacturing: number; Category: string; ImageSrc: string; } let filter: Array<any> = [ ["Category", "anyof", ["Automation", "Monitors"]], "or", [ ["Category", "=", "Televisions"], "and", ["Price", "between", [2000, 4000]] ] ], categories: string[] = [ "Video Players", "Televisions", "Monitors", "Projectors", "Automation" ], fields: Array<any> = [{ dataField: "Name" }, { dataField: "Price", dataType: "number", format: "currency" }, { dataField: "Current_Inventory", dataType: "number", caption: "Inventory" }, { dataField: "Category", filterOperations: ["=", "anyof"], lookup: { dataSource: categories } } ]; @Injectable() export class Service { getFields(): Array<any> { return fields; } getCategories(): string[] { return categories; } getFilter(): Array<any> { return filter; } }
// In real applications, you should not transpile code in the browser. You can see how to create your own application with Angular and DevExtreme here: // https://github.com/DevExpress/devextreme-angular/blob/master/README.md System.config({ transpiler: 'ts', typescriptOptions: { module: "commonjs", emitDecoratorMetadata: true, experimentalDecorators: true }, meta: { 'typescript': { "exports": "ts" } }, paths: { 'npm:': 'https://unpkg.com/' }, map: { 'ts': 'npm:plugin-typescript@8.0.0/lib/plugin.js', 'typescript': 'npm:typescript@3.4.5/lib/typescript.js', '@angular/core': 'npm:@angular/core@8.0.0/bundles/core.umd.js', '@angular/common': 'npm:@angular/common@8.0.0/bundles/common.umd.js', '@angular/compiler': 'npm:@angular/compiler@8.0.0/bundles/compiler.umd.js', '@angular/platform-browser': 'npm:@angular/platform-browser@8.0.0/bundles/platform-browser.umd.js', '@angular/platform-browser-dynamic': 'npm:@angular/platform-browser-dynamic@8.0.0/bundles/platform-browser-dynamic.umd.js', '@angular/router': 'npm:@angular/router@8.0.0/bundles/router.umd.js', '@angular/forms': 'npm:@angular/forms@8.0.0/bundles/forms.umd.js', '@angular/common/http': 'npm:@angular/common@8.0.0/bundles/common-http.umd.js', 'tslib': 'npm:tslib/tslib.js', 'rxjs': 'npm:rxjs@6.3.3', 'rxjs/operators': 'npm:rxjs@6.3.3/operators', 'devextreme': 'npm:devextreme@19.1', 'jszip': 'npm:jszip@3.1.3/dist/jszip.min.js', 'quill': 'npm:quill@1.3.6/dist/quill.js', 'devexpress-diagram': 'npm:devexpress-diagram', 'devextreme-angular': 'npm:devextreme-angular@19.1' }, packages: { 'app': { main: './app.component.ts', defaultExtension: 'ts' }, 'devextreme': { defaultExtension: 'js' }, 'rxjs': { main: 'index.js', defaultExtension: 'js' }, 'rxjs/operators': { main: 'index.js', defaultExtension: 'js' }, 'devextreme-angular': { main: 'index.js', defaultExtension: 'js' } } });
<!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" /> <link rel="stylesheet" type="text/css" href="https://cdn3.devexpress.com/jslib/19.1.4/css/dx.common.css" /> <link rel="stylesheet" type="text/css" href="https://cdn3.devexpress.com/jslib/19.1.4/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://unpkg.com/core-js@2.4.1/client/shim.min.js"></script> <script src="https://unpkg.com/zone.js@0.6.25/dist/zone.js"></script> <script src="https://unpkg.com/reflect-metadata@0.1.3/Reflect.js"></script> <script src="https://unpkg.com/systemjs@0.21.3/dist/system.js"></script> <script src="config.js"></script> <script> System.import('app').catch(console.error.bind(console)); </script> </head> <body class="dx-viewport"> <div class="demo-container"> <demo-app>Loading...</demo-app> </div> </body> </html>