Filtering

import { NgModule, Component, ViewChild, enableProdMode } from '@angular/core'; import { BrowserModule } from '@angular/platform-browser'; import { platformBrowserDynamic } from '@angular/platform-browser-dynamic'; import { DxDataGridComponent, DxDataGridModule, DxSelectBoxModule, DxCheckBoxModule } from 'devextreme-angular'; import { Order, Service } from './app.service'; if(!/localhost/.test(document.location.host)) { enableProdMode(); } @Component({ selector: 'demo-app', providers: [ Service ], templateUrl: 'app/app.component.html', styleUrls: ['app/app.component.css'], preserveWhitespaces: true }) export class AppComponent { @ViewChild(DxDataGridComponent) dataGrid: DxDataGridComponent; orders: Order[]; saleAmountHeaderFilter: any; applyFilterTypes: any; currentFilter: any; showFilterRow: boolean; showHeaderFilter: boolean; constructor(service: Service) { this.orders = service.getOrders(); this.showFilterRow = true; this.showHeaderFilter = true; this.applyFilterTypes = [{ key: "auto", name: "Immediately" }, { key: "onClick", name: "On Button Click" }]; this.saleAmountHeaderFilter = [{ text: "Less than $3000", value: ["SaleAmount", "<", 3000] }, { text: "$3000 - $5000", value: [ ["SaleAmount", ">=", 3000], ["SaleAmount", "<", 5000] ] }, { text: "$5000 - $10000", value: [ ["SaleAmount", ">=", 5000], ["SaleAmount", "<", 10000] ] }, { text: "$10000 - $20000", value: [ ["SaleAmount", ">=", 10000], ["SaleAmount", "<", 20000] ] }, { text: "Greater than $20000", value: ["SaleAmount", ">=", 20000] }]; this.currentFilter = this.applyFilterTypes[0].key; this.orderHeaderFilter = this.orderHeaderFilter.bind(this); } private static getOrderDay(rowData) { return (new Date(rowData.OrderDate)).getDay(); } calculateFilterExpression(value, selectedFilterOperations, target) { let column = this as any; if(target === "headerFilter" && value === "weekends") { return [[AppComponent.getOrderDay, "=", 0], "or", [AppComponent.getOrderDay, "=", 6]]; } return column.defaultCalculateFilterExpression.apply(this, arguments); } orderHeaderFilter(data) { data.dataSource.postProcess = (results) => { results.push({ text: "Weekends", value: "weekends" }); return results; }; } clearFilter() { this.dataGrid.instance.clearFilter(); } onInitialized(e) { e.component.columnOption("SaleAmount", { editorOptions: { format: "currency", showClearButton: true } }); } } @NgModule({ imports: [ BrowserModule, DxDataGridModule, DxSelectBoxModule, DxCheckBoxModule ], declarations: [AppComponent], bootstrap: [AppComponent] }) export class AppModule { } platformBrowserDynamic().bootstrapModule(AppModule);

::ng-deep #gridContainer { height: 440px; } ::ng-deep .options { padding: 20px; margin-top: 20px; background-color: rgba(191, 191, 191, 0.15); } ::ng-deep .caption { font-size: 18px; font-weight: 500; } ::ng-deep .option { margin-top: 10px; } ::ng-deep .option > span { margin-right: 10px; } ::ng-deep .option > .dx-selectbox { display: inline-block; vertical-align: middle; }

import { Injectable } from '@angular/core'; export class Order { ID: number; OrderNumber: number; OrderDate: string; DeliveryDate: string; SaleAmount: number; Terms: string; CustomerStoreCity: string; Employee: string; } let orders: Order[] = [{ "ID": 1, "OrderNumber": 35703, "OrderDate": "2017/04/10", "DeliveryDate": "2017/04/13 9:00", "SaleAmount": 11800, "Terms": "15 Days", "CustomerStoreCity": "Los Angeles, CA", "Employee": "Harv Mudd" }, { "ID": 4, "OrderNumber": 35711, "OrderDate": "2017/01/12", "DeliveryDate": "2017/01/13 9:00", "SaleAmount": 16050, "Terms": "15 Days", "CustomerStoreCity": "San Jose, CA", "Employee": "Jim Packard" }, { "ID": 5, "OrderNumber": 35714, "OrderDate": "2017/01/22", "DeliveryDate": "2017/01/27 9:00", "SaleAmount": 14750, "Terms": "15 Days", "CustomerStoreCity": "Las Vegas, NV", "Employee": "Harv Mudd" }, { "ID": 7, "OrderNumber": 35983, "OrderDate": "2017/02/07", "DeliveryDate": "2017/02/10 13:00", "SaleAmount": 3725, "Terms": "15 Days", "CustomerStoreCity": "Denver, CO", "Employee": "Todd Hoffman" }, { "ID": 11, "OrderNumber": 38466, "OrderDate": "2017/03/01", "DeliveryDate": "2017/03/03 17:45", "SaleAmount": 7800, "Terms": "15 Days", "CustomerStoreCity": "Los Angeles, CA", "Employee": "Harv Mudd" }, { "ID": 14, "OrderNumber": 39420, "OrderDate": "2017/02/15", "DeliveryDate": "2017/02/17 11:45", "SaleAmount": 20500, "Terms": "15 Days", "CustomerStoreCity": "San Jose, CA", "Employee": "Jim Packard" }, { "ID": 15, "OrderNumber": 39874, "OrderDate": "2017/02/04", "DeliveryDate": "2017/02/10 15:00", "SaleAmount": 9050, "Terms": "30 Days", "CustomerStoreCity": "Las Vegas, NV", "Employee": "Harv Mudd" }, { "ID": 18, "OrderNumber": 42847, "OrderDate": "2017/02/15", "DeliveryDate": "2017/02/17 8:30", "SaleAmount": 20400, "Terms": "30 Days", "CustomerStoreCity": "Casper, WY", "Employee": "Todd Hoffman" }, { "ID": 30, "OrderNumber": 57429, "OrderDate": "2017/05/16", "DeliveryDate": "2017/05/19 11:45", "SaleAmount": 11050, "Terms": "30 Days", "CustomerStoreCity": "Phoenix, AZ", "Employee": "Clark Morgan" }, { "ID": 32, "OrderNumber": 58292, "OrderDate": "2017/05/13", "DeliveryDate": "2017/05/19 14:30", "SaleAmount": 13500, "Terms": "15 Days", "CustomerStoreCity": "Los Angeles, CA", "Employee": "Harv Mudd" }, { "ID": 36, "OrderNumber": 62427, "OrderDate": "2017/01/27", "DeliveryDate": "2017/02/03 18:00", "SaleAmount": 23500, "Terms": "15 Days", "CustomerStoreCity": "Las Vegas, NV", "Employee": "Harv Mudd" }, { "ID": 39, "OrderNumber": 65977, "OrderDate": "2017/02/05", "DeliveryDate": "2017/02/10 13:15", "SaleAmount": 2550, "Terms": "15 Days", "CustomerStoreCity": "Casper, WY", "Employee": "Todd Hoffman" }, { "ID": 42, "OrderNumber": 68428, "OrderDate": "2017/04/10", "DeliveryDate": "2017/04/14 11:30", "SaleAmount": 10500, "Terms": "15 Days", "CustomerStoreCity": "Los Angeles, CA", "Employee": "Harv Mudd" }, { "ID": 43, "OrderNumber": 69477, "OrderDate": "2017/03/09", "DeliveryDate": "2017/03/10 12:00", "SaleAmount": 14200, "Terms": "15 Days", "CustomerStoreCity": "Anaheim, CA", "Employee": "Harv Mudd" }, { "ID": 46, "OrderNumber": 72947, "OrderDate": "2017/01/14", "DeliveryDate": "2017/01/20 9:00", "SaleAmount": 13350, "Terms": "30 Days", "CustomerStoreCity": "Las Vegas, NV", "Employee": "Harv Mudd" }, { "ID": 47, "OrderNumber": 73088, "OrderDate": "2017/03/25", "DeliveryDate": "2017/03/31 17:15", "SaleAmount": 8600, "Terms": "30 Days", "CustomerStoreCity": "Reno, NV", "Employee": "Clark Morgan" }, { "ID": 51, "OrderNumber": 77297, "OrderDate": "2017/04/30", "DeliveryDate": "2017/05/05 18:00", "SaleAmount": 10850, "Terms": "30 Days", "CustomerStoreCity": "Phoenix, AZ", "Employee": "Clark Morgan" }, { "ID": 56, "OrderNumber": 84744, "OrderDate": "2017/02/10", "DeliveryDate": "2017/02/17 14:00", "SaleAmount": 4650, "Terms": "30 Days", "CustomerStoreCity": "Las Vegas, NV", "Employee": "Harv Mudd" }, { "ID": 57, "OrderNumber": 85028, "OrderDate": "2017/05/17", "DeliveryDate": "2017/05/19 12:00", "SaleAmount": 2575, "Terms": "30 Days", "CustomerStoreCity": "Reno, NV", "Employee": "Clark Morgan" }, { "ID": 59, "OrderNumber": 87297, "OrderDate": "2017/04/21", "DeliveryDate": "2017/04/28 9:00", "SaleAmount": 14200, "Terms": "30 Days", "CustomerStoreCity": "Casper, WY", "Employee": "Todd Hoffman" }, { "ID": 65, "OrderNumber": 94726, "OrderDate": "2017/05/22", "DeliveryDate": "2017/05/26 13:30", "SaleAmount": 20500, "Terms": "15 Days", "CustomerStoreCity": "San Jose, CA", "Employee": "Jim Packard" }, { "ID": 66, "OrderNumber": 95266, "OrderDate": "2017/03/10", "DeliveryDate": "2017/03/17 11:45", "SaleAmount": 9050, "Terms": "15 Days", "CustomerStoreCity": "Las Vegas, NV", "Employee": "Harv Mudd" }, { "ID": 69, "OrderNumber": 98477, "OrderDate": "2017/01/01", "DeliveryDate": "2017/01/06 9:00", "SaleAmount": 23500, "Terms": "15 Days", "CustomerStoreCity": "Casper, WY", "Employee": "Todd Hoffman" }, { "ID": 78, "OrderNumber": 174884, "OrderDate": "2017/04/10", "DeliveryDate": "2017/04/14 8:30", "SaleAmount": 7200, "Terms": "30 Days", "CustomerStoreCity": "Denver, CO", "Employee": "Todd Hoffman" }, { "ID": 81, "OrderNumber": 188877, "OrderDate": "2017/02/11", "DeliveryDate": "2017/02/17 16:00", "SaleAmount": 8750, "Terms": "30 Days", "CustomerStoreCity": "Phoenix, AZ", "Employee": "Clark Morgan" }, { "ID": 82, "OrderNumber": 191883, "OrderDate": "2017/02/05", "DeliveryDate": "2017/02/10 18:30", "SaleAmount": 9900, "Terms": "30 Days", "CustomerStoreCity": "Los Angeles, CA", "Employee": "Harv Mudd" }, { "ID": 83, "OrderNumber": 192474, "OrderDate": "2017/01/21", "DeliveryDate": "2017/01/27 12:45", "SaleAmount": 12800, "Terms": "30 Days", "CustomerStoreCity": "Anaheim, CA", "Employee": "Harv Mudd" }, { "ID": 84, "OrderNumber": 193847, "OrderDate": "2017/03/21", "DeliveryDate": "2017/03/24 9:00", "SaleAmount": 14100, "Terms": "30 Days", "CustomerStoreCity": "San Diego, CA", "Employee": "Harv Mudd" }, { "ID": 85, "OrderNumber": 194877, "OrderDate": "2017/03/06", "DeliveryDate": "2017/03/10 18:15", "SaleAmount": 4750, "Terms": "30 Days", "CustomerStoreCity": "San Jose, CA", "Employee": "Jim Packard" }, { "ID": 86, "OrderNumber": 195746, "OrderDate": "2017/05/26", "DeliveryDate": "2017/06/02 17:00", "SaleAmount": 9050, "Terms": "30 Days", "CustomerStoreCity": "Las Vegas, NV", "Employee": "Harv Mudd" }, { "ID": 87, "OrderNumber": 197474, "OrderDate": "2017/03/02", "DeliveryDate": "2017/03/03 11:00", "SaleAmount": 6400, "Terms": "30 Days", "CustomerStoreCity": "Reno, NV", "Employee": "Clark Morgan" }, { "ID": 88, "OrderNumber": 198746, "OrderDate": "2017/05/09", "DeliveryDate": "2017/05/12 15:45", "SaleAmount": 15700, "Terms": "30 Days", "CustomerStoreCity": "Denver, CO", "Employee": "Todd Hoffman" }, { "ID": 91, "OrderNumber": 214222, "OrderDate": "2017/02/08", "DeliveryDate": "2017/02/10 9:45", "SaleAmount": 11050, "Terms": "30 Days", "CustomerStoreCity": "Phoenix, AZ", "Employee": "Clark Morgan" }]; @Injectable() export class Service { getOrders(): Order[] { return orders; } }

// 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@7.0.6/lib/plugin.js', 'typescript': 'npm:typescript@2.2.2/lib/typescript.js', '@angular/core': 'npm:@angular/core@7.1.3/bundles/core.umd.js', '@angular/common': 'npm:@angular/common@7.1.3/bundles/common.umd.js', '@angular/compiler': 'npm:@angular/compiler@7.1.3/bundles/compiler.umd.js', '@angular/platform-browser': 'npm:@angular/platform-browser@7.1.3/bundles/platform-browser.umd.js', '@angular/platform-browser-dynamic': 'npm:@angular/platform-browser-dynamic@7.1.3/bundles/platform-browser-dynamic.umd.js', '@angular/router': 'npm:@angular/router@7.1.3/bundles/router.umd.js', '@angular/forms': 'npm:@angular/forms@7.1.3/bundles/forms.umd.js', '@angular/common/http': 'npm:@angular/common@7.1.3/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.3/css/dx.common.css" /> <link rel="dx-theme" data-theme="generic.light" href="https://cdn3.devexpress.com/jslib/19.1.3/css/dx.light.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>