Filtering

Documentation

This example demonstrates the DataGrid’s built-in filtering and searching capabilities. The filter row, located under the column headers, allows a user to type any value and select filter operations. With the header filter, which is called by clicking the filter icon in any column header, a user can choose from a set of predefined values. The search panel at the top of the DataGrid allows searching for values in all columns at once.

See more Hide details

Prev Demo Next Demo

Was this demo helpful?

Thank you!

Feel free to share demo-related thoughts here.
If you have technical questions, please create a support ticket in the DevExpress Support Center.

Send Feedback

Thank you!
We appreciate your feedback.

jQuery

Angular

Vue

React

AngularJS

ASP.NET Core

ASP.NET MVC

Copy to CodeSandBox

Apply

Reset

<template> <div> <DxDataGrid id="gridContainer" :ref="dataGridRefName" :data-source="orders" :show-borders="true" > <DxFilterRow :visible="showFilterRow" :apply-filter="currentFilter" /> <DxHeaderFilter :visible="showHeaderFilter" /> <DxSearchPanel :visible="true" :width="240" placeholder="Search..." /> <DxColumn :width="140" :header-filter="{ groupInterval: 10000 }" data-field="OrderNumber" caption="Invoice Number" /> <DxColumn :width="120" :calculate-filter-expression="calculateFilterExpression" :header-filter="{ dataSource: orderHeaderFilter }" data-field="OrderDate" alignment="right" data-type="date" /> <DxColumn :width="180" data-field="DeliveryDate" alignment="right" data-type="datetime" format="M/d/yyyy, HH:mm" /> <DxColumn :header-filter="{ dataSource: saleAmountHeaderFilter }" :editor-options="{ format: 'currency', showClearButton: true }" data-field="SaleAmount" alignment="right" format="currency" /> <DxColumn data-field="Employee"/> <DxColumn :header-filter="{ allowSearch: true }" data-field="CustomerStoreCity" caption="City" /> </DxDataGrid> <div class="options"> <div class="caption">Options</div> <div class="option"> <span>Apply Filter</span> <DxSelectBox id="useFilterApplyButton" :items="applyFilterTypes" :value.sync="currentFilter" :disabled="!showFilterRow" value-expr="key" display-expr="name" /> </div> <div class="option"> <DxCheckBox :value.sync="showFilterRow" text="Filter Row" @valueChanged="clearFilter()" /> </div> <div class="option"> <DxCheckBox :value.sync="showHeaderFilter" text="Header Filter" @valueChanged="clearFilter()" /> </div> </div> </div> </template> <script> import { DxDataGrid, DxColumn, DxHeaderFilter, DxSearchPanel, DxFilterRow } from 'devextreme-vue/data-grid'; import DxSelectBox from 'devextreme-vue/select-box'; import DxCheckBox from 'devextreme-vue/check-box'; import service from './data.js'; const getOrderDay = (rowData) => { return (new Date(rowData.OrderDate)).getDay(); }; export default { components: { DxSelectBox, DxCheckBox, DxDataGrid, DxColumn, DxHeaderFilter, DxSearchPanel, DxFilterRow }, data() { const applyFilterTypes = [ { key: 'auto', name: 'Immediately' }, { key: 'onClick', name: 'On Button Click' }], currentFilter = applyFilterTypes[0].key; return { orders: service.getOrders(), showFilterRow: true, showHeaderFilter: true, applyFilterTypes, saleAmountHeaderFilter: [{ text: 'Less than $3000', value: ['SaleAmount', '<', 3000] }, { text: '$3000 - $5000', value: [ ['SaleAmount', '>=', 3000], ['SaleAmount', '<', 5000] ] }, { text: '$5000 - $10000', value: [ ['SaleAmount', '>=', 5000], ['SaleAmount', '<', 10000] ] }, { text: '$10000 - $20000', value: [ ['SaleAmount', '>=', 10000], ['SaleAmount', '<', 20000] ] }, { text: 'Greater than $20000', value: ['SaleAmount', '>=', 20000] }], calculateFilterExpression(value, selectedFilterOperations, target) { let column = this; if(target === 'headerFilter' && value === 'weekends') { return [[getOrderDay, '=', 0], 'or', [getOrderDay, '=', 6]]; } return column.defaultCalculateFilterExpression.apply(this, arguments); }, currentFilter, dataGridRefName: 'dataGrid' }; }, methods: { orderHeaderFilter(data) { data.dataSource.postProcess = (results) => { results.push({ text: 'Weekends', value: 'weekends' }); return results; }; }, clearFilter() { this.$refs[this.dataGridRefName].instance.clearFilter(); } } }; </script> <style scoped> #gridContainer { height: 440px; } .options { padding: 20px; margin-top: 20px; background-color: rgba(191, 191, 191, 0.15); } .caption { font-size: 18px; font-weight: 500; } .option { margin-top: 10px; } .option > span { margin-right: 10px; } .option > .dx-selectbox { display: inline-block; vertical-align: middle; } </style>

import Vue from 'vue'; import App from './App.vue'; new Vue({ el: '#app', components: { App }, template: '<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.6/css/dx.common.css" /> <link rel="stylesheet" type="text/css" href="https://cdn3.devexpress.com/jslib/20.1.6/css/dx.light.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>

System.config({ transpiler: 'plugin-babel', meta: { '*.vue': { loader: 'vue-loader' }, }, paths: { 'npm:': 'https://unpkg.com/' }, map: { 'vue': 'npm:vue@2.6.3/dist/vue.esm.browser.js', 'vue-loader': 'npm:dx-systemjs-vue-browser@latest/index.js', 'devextreme': 'npm:devextreme@20.1', 'devextreme-vue': 'npm:devextreme-vue@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.9', 'devexpress-gantt': 'npm:devexpress-gantt@1.0.7', 'plugin-babel': 'npm:systemjs-plugin-babel@0/plugin-babel.js', 'systemjs-babel-build': 'npm:systemjs-plugin-babel@0/systemjs-babel-browser.js' }, packages: { 'devextreme-vue': { main: 'index.js' }, 'devextreme': { defaultExtension: 'js' }, 'devextreme/events/utils': { main: 'index' }, 'devextreme/events': { main: 'index' }, }, babelOptions: { sourceMaps: false, stage0: true } });