Your search did not match any results.
Data Grid

Master-Detail View

Documentation

The DataGrid widget supports the master-detail interface. This interface supplies a standard data row with an expandable section that contains detail data rows. Master-detail data representation is configured using the masterDetail object. In this example, each data row is supplied with a detail section that contains another DataGrid widget.

Copy to CodeSandBox
Apply
Reset
<dx-data-grid id="gridContainer" [dataSource]="employees" [masterDetail]="{ enabled: true, template: 'detail' }" keyExpr="ID" [showBorders]="true"> <dxi-column dataField="Prefix" [width]="70" caption="Title"></dxi-column> <dxi-column dataField="FirstName"></dxi-column> <dxi-column dataField="LastName"></dxi-column> <dxi-column dataField="Position" [width]="170"></dxi-column> <dxi-column dataField="State" [width]="125"></dxi-column> <dxi-column dataField="BirthDate" dataType="date"></dxi-column> <div *dxTemplate="let employee of 'detail'"> <div class="master-detail-caption">{{employee.data.FirstName + " " + employee.data.LastName + "'s Tasks:"}}</div> <dx-data-grid [dataSource]="getTasks(employee.key)" [showBorders]="true" [columnAutoWidth]="true"> <dxi-column dataField="Subject"></dxi-column> <dxi-column dataField="StartDate" dataType="date"></dxi-column> <dxi-column dataField="DueDate" dataType="date"></dxi-column> <dxi-column dataField="Priority"></dxi-column> <dxi-column dataType="boolean" caption="Completed" [calculateCellValue]="completedValue"></dxi-column> </dx-data-grid> </div> </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, DxTemplateModule } from 'devextreme-angular'; import { Employee, Service, Task } from './app.service'; import DataSource from 'devextreme/data/data_source'; import ArrayStore from 'devextreme/data/array_store'; if (!/localhost/.test(document.location.host)) { enableProdMode(); } @Component({ selector: 'demo-app', templateUrl: 'app/app.component.html', styleUrls: ['app/app.component.css'], providers: [Service] }) export class AppComponent { employees: Employee[]; tasks: Task[]; tasksDataSourceStorage: any; constructor(private service: Service) { this.employees = service.getEmployees(); this.tasks = service.getTasks(); this.tasksDataSourceStorage = []; } completedValue(rowData) { return rowData.Status == "Completed"; } getTasks(key) { let item = this.tasksDataSourceStorage.find((i) => i.key === key); if (!item) { item = { key: key, dataSourceInstance: new DataSource({ store: new ArrayStore({ data: this.tasks, key: "ID" }), filter: ["EmployeeID", "=", key] }) }; this.tasksDataSourceStorage.push(item) } return item.dataSourceInstance; } } @NgModule({ imports: [ BrowserModule, DxDataGridModule, DxTemplateModule ], declarations: [AppComponent], bootstrap: [AppComponent] }) export class AppModule { } platformBrowserDynamic().bootstrapModule(AppModule);
::ng-deep #gridContainer { height: 440px; } ::ng-deep .master-detail-caption { padding: 0 0 5px 10px; font-size: 14px; font-weight: bold; }
import { Injectable } from '@angular/core'; export class Task { ID: number; Subject: string; StartDate: string; DueDate: string; Status: string; Priority: string; Completion: number; EmployeeID: number; } export class Employee { ID: number; FirstName: string; LastName: string; Prefix: string; Position: string; BirthDate: string; State: string; } let employees: Employee[] = [{ "ID": 1, "Prefix": "Mr.", "FirstName": "John", "LastName": "Heart", "Position": "CEO", "State": "California", "BirthDate": "1964/03/16" }, { "ID": 2, "Prefix": "Mrs.", "FirstName": "Olivia", "LastName": "Peyton", "Position": "Sales Assistant", "State": "California", "BirthDate": "1981/06/03" }, { "ID": 3, "Prefix": "Mr.", "FirstName": "Robert", "LastName": "Reagan", "Position": "CMO", "State": "Arkansas", "BirthDate": "1974/09/07" }, { "ID": 4, "Prefix": "Ms.", "FirstName": "Greta", "LastName": "Sims", "Position": "HR Manager", "State": "Georgia", "BirthDate": "1977/11/22" }, { "ID": 5, "Prefix": "Mr.", "FirstName": "Brett", "LastName": "Wade", "Position": "IT Manager", "State": "Idaho", "BirthDate": "1968/12/01" }, { "ID": 6, "Prefix": "Mrs.", "FirstName": "Sandra", "LastName": "Johnson", "Position": "Controller", "State": "Utah", "BirthDate": "1974/11/15" }, { "ID": 7, "Prefix": "Mr.", "FirstName": "Kevin", "LastName": "Carter", "Position": "Shipping Manager", "State": "California", "BirthDate": "1978/01/09" }, { "ID": 8, "Prefix": "Ms.", "FirstName": "Cynthia", "LastName": "Stanwick", "Position": "HR Assistant", "State": "Arkansas", "BirthDate": "1985/06/05" }, { "ID": 9, "Prefix": "Dr.", "FirstName": "Kent", "LastName": "Samuelson", "Position": "Ombudsman", "State": "Missouri", "BirthDate": "1972/09/11" }] let tasks: Task[] = [{ "ID": 1, "Subject": "Prepare 2013 Financial", "StartDate": "2013/01/15", "DueDate": "2013/01/31", "Status": "Completed", "Priority": "High", "Completion": 100, "EmployeeID": 8 }, { "ID": 2, "Subject": "Prepare 3013 Marketing Plan", "StartDate": "2013/01/01", "DueDate": "2013/01/31", "Status": "Completed", "Priority": "High", "Completion": 100, "EmployeeID": 5 }, { "ID": 3, "Subject": "Update Personnel Files", "StartDate": "2013/02/03", "DueDate": "2013/02/28", "Status": "Completed", "Priority": "High", "Completion": 100, "EmployeeID": 2 }, { "ID": 4, "Subject": "Review Health Insurance Options Under the Affordable Care Act", "StartDate": "2013/02/12", "DueDate": "2013/04/25", "Status": "In Progress", "Priority": "High", "Completion": 50, "EmployeeID": 2 }, { "ID": 5, "Subject": "Choose between PPO and HMO Health Plan", "StartDate": "2013/02/15", "DueDate": "2013/04/15", "Status": "In Progress", "Priority": "High", "Completion": 75, "EmployeeID": 1 }, { "ID": 6, "Subject": "Google AdWords Strategy", "StartDate": "2013/02/16", "DueDate": "2013/02/28", "Status": "Completed", "Priority": "High", "Completion": 100, "EmployeeID": 1 }, { "ID": 7, "Subject": "New Brochures", "StartDate": "2013/02/17", "DueDate": "2013/02/24", "Status": "Completed", "Priority": "Normal", "Completion": 100, "EmployeeID": 1 }, { "ID": 11, "Subject": "Rollout of New Website and Marketing Brochures", "StartDate": "2013/02/20", "DueDate": "2013/02/28", "Status": "Completed", "Priority": "High", "Completion": 100, "EmployeeID": 5 }, { "ID": 12, "Subject": "Update Sales Strategy Documents", "StartDate": "2013/02/20", "DueDate": "2013/02/22", "Status": "Completed", "Priority": "Normal", "Completion": 100, "EmployeeID": 9 }, { "ID": 15, "Subject": "Review 2012 Sales Report and Approve 2013 Plans", "StartDate": "2013/02/23", "DueDate": "2013/02/28", "Status": "Completed", "Priority": "Normal", "Completion": 100, "EmployeeID": 5 }, { "ID": 16, "Subject": "Deliver R&D Plans for 2013", "StartDate": "2013/03/01", "DueDate": "2013/03/10", "Status": "Completed", "Priority": "High", "Completion": 100, "EmployeeID": 3 }, { "ID": 20, "Subject": "Approve Hiring of John Jeffers", "StartDate": "2013/03/02", "DueDate": "2013/03/12", "Status": "Completed", "Priority": "Normal", "Completion": 100, "EmployeeID": 4 }, { "ID": 20, "Subject": "Approve Hiring of John Jeffers", "StartDate": "2013/03/02", "DueDate": "2013/03/12", "Status": "Completed", "Priority": "Normal", "Completion": 100, "EmployeeID": 6 }, { "ID": 21, "Subject": "Non-Compete Agreements", "StartDate": "2013/03/12", "DueDate": "2013/03/14", "Status": "Completed", "Priority": "Low", "Completion": 100, "EmployeeID": 2 }, { "ID": 22, "Subject": "Update NDA Agreement", "StartDate": "2013/03/14", "DueDate": "2013/03/16", "Status": "Completed", "Priority": "High", "Completion": 100, "EmployeeID": 1 }, { "ID": 23, "Subject": "Update Employee Files with New NDA", "StartDate": "2013/03/16", "DueDate": "2013/03/26", "Status": "Need Assistance", "Priority": "Normal", "Completion": 90, "EmployeeID": 4 }, { "ID": 24, "Subject": "Update Employee Files with New NDA", "StartDate": "2013/03/16", "DueDate": "2013/03/26", "Status": "Need Assistance", "Priority": "Normal", "Completion": 90, "EmployeeID": 6 }, { "ID": 25, "Subject": "Sign Updated NDA", "StartDate": "2013/03/20", "DueDate": "2013/03/25", "Status": "Completed", "Priority": "Urgent", "Completion": 100, "EmployeeID": 7 }, { "ID": 26, "Subject": "Sign Updated NDA", "StartDate": "2013/03/20", "DueDate": "2013/03/25", "Status": "Completed", "Priority": "Urgent", "Completion": 100, "EmployeeID": 8 }, { "ID": 27, "Subject": "Sign Updated NDA", "StartDate": "2013/03/20", "DueDate": "2013/03/25", "Status": "Need Assistance", "Priority": "Urgent", "Completion": 25, "EmployeeID": 9 }, { "ID": 35, "Subject": "Update Revenue Projections", "StartDate": "2013/03/24", "DueDate": "2013/04/07", "Status": "Completed", "Priority": "Normal", "Completion": 100, "EmployeeID": 8 }, { "ID": 36, "Subject": "Review Revenue Projections", "StartDate": "2013/03/25", "DueDate": "2013/04/06", "Status": "Completed", "Priority": "High", "Completion": 100, "EmployeeID": 9 }, { "ID": 40, "Subject": "Provide New Health Insurance Docs", "StartDate": "2013/03/28", "DueDate": "2013/04/07", "Status": "Completed", "Priority": "Normal", "Completion": 100, "EmployeeID": 4 }, { "ID": 41, "Subject": "Provide New Health Insurance Docs", "StartDate": "2013/03/28", "DueDate": "2013/04/07", "Status": "Completed", "Priority": "Normal", "Completion": 100, "EmployeeID": 6 }, { "ID": 50, "Subject": "Give Final Approval for Refunds", "StartDate": "2013/05/05", "DueDate": "2013/05/15", "Status": "Completed", "Priority": "Normal", "Completion": 100, "EmployeeID": 2 }, { "ID": 52, "Subject": "Review Product Recall Report by Engineering Team", "StartDate": "2013/05/17", "DueDate": "2013/05/20", "Status": "Completed", "Priority": "High", "Completion": 100, "EmployeeID": 1 }, { "ID": 55, "Subject": "Review Overtime Report", "StartDate": "2013/06/10", "DueDate": "2013/06/14", "Status": "Completed", "Priority": "Normal", "Completion": 100, "EmployeeID": 7 }, { "ID": 60, "Subject": "Refund Request Template", "StartDate": "2013/06/17", "DueDate": "2014/04/01", "Status": "Deferred", "Priority": "Normal", "Completion": 0, "EmployeeID": 9 }, { "ID": 71, "Subject": "Upgrade Server Hardware", "StartDate": "2013/07/22", "DueDate": "2013/07/31", "Status": "Completed", "Priority": "Urgent", "Completion": 100, "EmployeeID": 7 }, { "ID": 72, "Subject": "Upgrade Personal Computers", "StartDate": "2013/07/24", "DueDate": "2014/04/30", "Status": "In Progress", "Priority": "Normal", "Completion": 85, "EmployeeID": 7 }, { "ID": 74, "Subject": "Decide on Mobile Devices to Use in the Field", "StartDate": "2013/07/30", "DueDate": "2013/08/02", "Status": "Completed", "Priority": "High", "Completion": 100, "EmployeeID": 3 }, { "ID": 78, "Subject": "Try New Touch-Enabled WinForms Apps", "StartDate": "2013/08/11", "DueDate": "2013/08/15", "Status": "Completed", "Priority": "Normal", "Completion": 100, "EmployeeID": 3 }, { "ID": 81, "Subject": "Review Site Up-Time Report", "StartDate": "2013/08/24", "DueDate": "2013/08/30", "Status": "Completed", "Priority": "Urgent", "Completion": 100, "EmployeeID": 5 }, { "ID": 99, "Subject": "Submit D&B Number to ISP for Credit Approval", "StartDate": "2013/11/04", "DueDate": "2013/11/07", "Status": "Completed", "Priority": "High", "Completion": 100, "EmployeeID": 8 }, { "ID": 117, "Subject": "Approval on Converting to New HDMI Specification", "StartDate": "2014/01/11", "DueDate": "2014/01/31", "Status": "Deferred", "Priority": "Normal", "Completion": 75, "EmployeeID": 3 }, { "ID": 138, "Subject": "Review HR Budget Company Wide", "StartDate": "2014/03/20", "DueDate": "2014/03/25", "Status": "In Progress", "Priority": "Normal", "Completion": 40, "EmployeeID": 6 }, { "ID": 145, "Subject": "Final Budget Review", "StartDate": "2014/03/26", "DueDate": "2014/03/27", "Status": "In Progress", "Priority": "High", "Completion": 25, "EmployeeID": 6 }] @Injectable() export class Service { getEmployees() { return employees; } getTasks(){ return tasks; } }
// 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" /> <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>