Remote Grouping
Documentation
The DataGrid widget allows your end users to shape data as needs dictate. In this example, we demonstrate the use of the built-in data grouping feature against a remote data source. Data is provided by an OData service and grid content is grouped by both Status and Priority columns. Note that this demo uses the DataGrid in a virtual mode and loads data on-demand as the grid content is scrolled vertically.
Thank you!
We appreciate your feedback.
We appreciate your feedback.
import React from 'react';
import DataGrid, { Column, GroupPanel, Scrolling, Lookup } from 'devextreme-react/data-grid';
import 'devextreme/data/odata/store';
const dataSourceOptions = {
store: {
type: 'odata',
url: 'https://js.devexpress.com/Demos/DevAV/odata/Tasks'
},
expand: 'ResponsibleEmployee',
select: [
'Task_ID',
'Task_Subject',
'Task_Start_Date',
'Task_Due_Date',
'Task_Status',
'Task_Priority',
'ResponsibleEmployee/Employee_Full_Name'
]
};
const priority = [
{ name: 'High', value: 4 },
{ name: 'Urgent', value: 3 },
{ name: 'Normal', value: 2 },
{ name: 'Low', value: 1 }
];
class App extends React.Component {
render() {
return (
<DataGrid
id={'gridContainer'}
dataSource={dataSourceOptions}
showBorders={true}
>
<GroupPanel visible={true} />
<Scrolling mode={'virtual'} />
<Column
dataField={'Task_ID'}
width={90} />
<Column
dataField={'Task_Subject'}
caption={'Subject'}
width={190} />
<Column
dataField={'Task_Status'}
caption={'Status'}
groupIndex={0} />
<Column
dataField={'Task_Priority'}
caption={'Priority'}
groupIndex={1}>
<Lookup
dataSource={priority}
displayExpr={'name'}
valueExpr={'value'} />
</Column>
<Column
dataField={'ResponsibleEmployee.Employee_Full_Name'}
caption={'Assigned To'}
allowGrouping={false}
allowSorting={false} />
<Column
dataField={'Task_Start_Date'}
caption={'Start Date'}
dataType={'date'} />
<Column
dataField={'Task_Due_Date'}
caption={'Due Date'}
dataType={'date'} />
</DataGrid>
);
}
}
export default App;
import React from 'react';
import ReactDOM from 'react-dom';
import App from './App.js';
ReactDOM.render(
<App />,
document.getElementById('app')
);
<!DOCTYPE html>
<html>
<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/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" />
<link rel="stylesheet" type ="text/css" href ="styles.css" />
<script src="https://unpkg.com/core-js@2.4.1/client/shim.min.js"></script>
<script src="https://unpkg.com/systemjs@0.21.3/dist/system.js"></script>
<script type="text/javascript" src="config.js"></script>
<script type="text/javascript">
System.import('./index.js');
</script>
</head>
<body class="dx-viewport">
<div class="demo-container">
<div id="app"></div>
</div>
</body>
</html>
#gridContainer {
height: 420px;
}
System.config({
transpiler: 'plugin-babel',
paths: {
'npm:': 'https://unpkg.com/'
},
defaultExtension: 'js',
map: {
'react': 'npm:react@16/umd/react.development.js',
'react-dom': 'npm:react-dom@16/umd/react-dom.development.js',
'prop-types': 'npm:prop-types/prop-types.js',
'devextreme': 'npm:devextreme@18.2',
'devextreme-react': 'npm:devextreme-react@18.2',
'jszip': 'npm:jszip@3.1.3/dist/jszip.min.js',
'quill': 'npm:quill@1.3.6/dist/quill.js',
// SystemJS plugins
'plugin-babel': 'npm:systemjs-plugin-babel@0/plugin-babel.js',
'systemjs-babel-build':
'npm:systemjs-plugin-babel@0/systemjs-babel-browser.js'
},
packages: {
'devextreme': {
defaultExtension: 'js'
},
'devextreme-react': {
main: 'index.js'
}
},
babelOptions: {
sourceMaps: false,
stage0: true,
react: true
}
});