<div class="filter-container">
<dx-filter-builder
[fields]="fields"
[(value)]="filter">
</dx-filter-builder>
<dx-button
text="Apply Filter"
type="default"
(onClick)="buttonClick()">
</dx-button>
<div class="dx-clearfix"></div>
</div>
<dx-data-grid
[dataSource]="dataSource"
[filterValue]="gridFilterValue"
[showBorders]="true"
[columns]="fields"
[height]="300">
</dx-data-grid>
import { NgModule, Component, enableProdMode } from '@angular/core';
import { BrowserModule } from '@angular/platform-browser';
import { platformBrowserDynamic } from '@angular/platform-browser-dynamic';
import { DxDataGridModule,
DxButtonModule,
DxFilterBuilderModule } from 'devextreme-angular';
import DataSource from 'devextreme/data/data_source';
import ODataStore from 'devextreme/data/odata/store';
import { 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']
})
export class AppComponent {
dataSource: any;
fields: Array<any>;
filter: any;
gridFilterValue: any;
constructor(service: Service) {
this.fields = service.getFields();
this.filter = service.getFilter();
this.gridFilterValue = this.filter;
this.dataSource = new DataSource({
store: new ODataStore({
fieldTypes: {
"Product_Cost": "Decimal",
"Product_Sale_Price": "Decimal",
"Product_Retail_Price": "Decimal"
},
url: "https://js.devexpress.com/Demos/DevAV/odata/Products",
}),
select: [
'Product_ID',
'Product_Name',
'Product_Cost',
'Product_Sale_Price',
'Product_Retail_Price',
'Product_Current_Inventory'
]
});
}
buttonClick() {
this.gridFilterValue = this.filter;
}
}
@NgModule({
imports: [
BrowserModule,
DxDataGridModule,
DxButtonModule,
DxFilterBuilderModule
],
declarations: [AppComponent],
bootstrap: [AppComponent]
})
export class AppModule { }
platformBrowserDynamic().bootstrapModule(AppModule);
::ng-deep .filter-container {
background-color: rgba(191, 191, 191, 0.15);
padding: 5px;
width: 500px;
margin-bottom: 25px;
}
::ng-deep .dx-filterbuilder {
padding: 10px;
}
::ng-deep .dx-button {
margin: 10px;
float: right;
}
::ng-deep .dx-filterbuilder .dx-numberbox {
width: 80px;
}
import { Injectable } from '@angular/core';
let filter: Array<any> = [
["Product_Current_Inventory", "<>", 0],
"or",
[
["Product_Name", "contains", "HD"],
"and",
["Product_Cost", "<", 200]
]
],
fields: Array<any> = [
{
caption: "ID",
width: 50,
dataField: "Product_ID",
dataType: "number"
}, {
dataField: "Product_Name",
dataType: "string"
}, {
caption: "Cost",
dataField: "Product_Cost",
dataType: "number",
format: "currency"
}, {
dataField: "Product_Sale_Price",
caption: "Sale Price",
dataType: "number",
format: "currency"
}, {
dataField: "Product_Retail_Price",
caption: "Retail Price",
dataType: "number",
format: "currency"
}, {
dataField: "Product_Current_Inventory",
dataType: "number",
caption: "Inventory"
}
];
@Injectable()
export class Service {
getFields(): Array<any> {
return fields;
}
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://js.devexpress.com/Documentation/Guide/Angular_Components/Getting_Started/Create_a_DevExtreme_Application/
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.2',
'jszip': 'npm:jszip@3.1.3/dist/jszip.min.js',
'quill': 'npm:quill@1.3.7/dist/quill.js',
'devexpress-diagram': 'npm:devexpress-diagram',
'devexpress-gantt': 'npm:devexpress-gantt',
'devextreme-angular': 'npm:devextreme-angular@19.2'
},
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.2.4/css/dx.common.css" />
<link rel="stylesheet" type="text/css" href="https://cdn3.devexpress.com/jslib/19.2.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>