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 CodePen
Apply
Reset
var DemoApp = angular.module('DemoApp', ['dx']); DemoApp.controller('DemoController', function DemoController($scope) { $scope.gridOptions = { dataSource: employees, keyExpr: "ID", showBorders: true, columns: [{ dataField: "Prefix", caption: "Title", width: 70 }, "FirstName", "LastName", { dataField: "Position", width: 170 }, { dataField: "State", width: 125 }, { dataField: "BirthDate", dataType: "date" } ], masterDetail: { enabled: true, template: "detail" } }; $scope.getDetailGridSettings = function (key) { return { dataSource: new DevExpress.data.DataSource({ store: new DevExpress.data.ArrayStore({ key: "ID", data: tasks }), filter: ["EmployeeID", "=", key] }), columnAutoWidth: true, showBorders: true, columns: ['Subject', { dataField: 'StartDate', dataType: 'date' }, { dataField: 'DueDate', dataType: 'date' }, 'Priority', { caption: 'Completed', dataType: 'boolean', calculateCellValue: function (rowData) { return rowData.Status == "Completed"; } }] }; } });
<!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" /> <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.1.0/jquery.min.js"></script> <script>window.jQuery || document.write(decodeURIComponent('%3Cscript src="js/jquery.min.js"%3E%3C/script%3E'))</script> <link rel="stylesheet" type="text/css" href="https://cdn3.devexpress.com/jslib/18.2.7/css/dx.common.css" /> <link rel="dx-theme" data-theme="generic.light" href="https://cdn3.devexpress.com/jslib/18.2.7/css/dx.light.css" /> <script src="https://ajax.googleapis.com/ajax/libs/angularjs/1.3.16/angular.min.js"></script> <script>window.angular || document.write(decodeURIComponent('%3Cscript src="js/angular.min.js"%3E%3C\/script%3E'))</script> <script src="https://cdn3.devexpress.com/jslib/18.2.7/js/dx.all.js"></script> <script src="data.js"></script> <link rel="stylesheet" type ="text/css" href ="styles.css" /> <script src="index.js"></script> </head> <body class="dx-viewport"> <div class="demo-container" ng-app="DemoApp" ng-controller="DemoController"> <div id="gridContainer" dx-data-grid="gridOptions" dx-item-alias="employee"> <div data-options="dxTemplate: {name: 'detail'}"> <div class="master-detail-caption">{{employee.data.FirstName + " " + employee.data.LastName + "'s Tasks:"}}</div> <div dx-data-grid="getDetailGridSettings(employee.key)"></div> </div> </div> </div> </body> </html>
#gridContainer { height: 440px; } .master-detail-caption { padding: 0 0 5px 10px; font-size: 14px; font-weight: bold; }
var employees = [{ "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" }] var tasks = [{ "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 }]