Your search did not match any results.
Data Grid

Filtering API

The DataGrid includes the following API you can use to filter data:

In this demo, you can use the SelectBox widget to filter the grid's dataSource. The "All" item calls the clearFilter() method and the other items call the filter(filterExpr) method.

Copy to CodeSandBox
Apply
Reset
import React from 'react'; import DataGrid, { Column } from 'devextreme-react/data-grid'; import SelectBox from 'devextreme-react/select-box'; 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_Status', 'ResponsibleEmployee/Employee_Full_Name' ] }; const statuses = ['All', 'Not Started', 'In Progress', 'Need Assistance', 'Deferred', 'Completed']; class App extends React.Component { constructor(props) { super(props); this.state = { filterStatus: statuses[0] }; this.onValueChanged = this.onValueChanged.bind(this); } render() { return ( <div> <div className="left-side"> <div className="logo"> <img src="../../../../images/logo-devav.png" /> &nbsp; <img src="../../../../images/logo-tasks.png" /> </div> </div> <div className="right-side"> <SelectBox items={statuses} value={this.state.filterStatus} onValueChanged={this.onValueChanged} /> </div> <DataGrid id="gridContainer" ref={ref => this.dataGrid = ref} dataSource={dataSourceOptions} columnAutoWidth={true} showBorders={true} > <Column dataField="Task_ID" width={80} /> <Column dataField="Task_Start_Date" caption="Start Date" dataType="date" /> <Column allowSorting={false} dataField="ResponsibleEmployee.Employee_Full_Name" cssClass="employee" caption="Assigned To" /> <Column dataField="Task_Subject" caption="Subject" width={350} /> <Column dataField="Task_Status" caption="Status" /> </DataGrid> </div> ); } onValueChanged({ value }) { const dataGrid = this.dataGrid.instance; if (value === 'All') { dataGrid.clearFilter(); } else { dataGrid.filter(['Task_Status', '=', value]); } this.setState({ filterStatus: value }); } } 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/20.1.8/css/dx.common.css" /> <link rel="stylesheet" type="text/css" href="https://cdn3.devexpress.com/jslib/20.1.8/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>
.right-side { position: absolute; right: 1px; top: 6px; } .logo { line-height: 48px; } .logo img { vertical-align: middle; margin: 0 5px; } .dx-row.dx-data-row .employee { color: #bf4e6a; font-weight: bold; } #gridContainer { margin: 20px 0; height: 400px; }
System.config({ transpiler: 'plugin-babel', meta: { }, 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@20.1', 'devextreme-react': 'npm:devextreme-react@20.1', 'jszip': 'npm:jszip@3.1.3/dist/jszip.min.js', 'quill': 'npm:quill@1.3.7/dist/quill.js', 'devexpress-diagram': 'npm:devexpress-diagram@1.0.17', 'devexpress-gantt': 'npm:devexpress-gantt@1.0.10', // 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' }, 'devextreme/events/utils': { main: 'index' }, 'devextreme/events': { main: 'index' }, }, babelOptions: { sourceMaps: false, stage0: true, react: true } });