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.
Thank you!
We appreciate your feedback.
We appreciate your feedback.
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/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://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/19.1.3/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
}]