Filtering API
Documentation
The DataGrid widget ships with an integrated filtering API, allowing you apply filters in code. In this example, the grid’s filter function is called to filter data based on selections made within the drop-down menu above the DataGrid.
Feel free to share demo-related thoughts here.
If you have technical questions, please create a support ticket in the DevExpress Support Center.
If you have technical questions, please create a support ticket in the DevExpress Support Center.
Thank you!
We appreciate your feedback.
We appreciate your feedback.
<template>
<div>
<div class="left-side">
<div class="logo">
<img src="../../../../images/logo-devav.png">
<img src="../../../../images/logo-tasks.png">
</div>
</div>
<div class="right-side">
<DxSelectBox
:items="statuses"
:value="statuses[0]"
@value-changed="onValueChanged"
/>
</div>
<DxDataGrid
id="gridContainer"
:ref="dataGridRefName"
:data-source="dataSource"
:column-auto-width="true"
:show-borders="true"
>
<DxColumn
:width="80"
data-field="Task_ID"
/>
<DxColumn
data-field="Task_Start_Date"
data-type="date"
caption="Start Date"
/>
<DxColumn
:allow-sorting="false"
data-field="ResponsibleEmployee.Employee_Full_Name"
css-class="employee"
caption="Assigned To"
/>
<DxColumn
:width="350"
data-field="Task_Subject"
caption="Subject"
/>
<DxColumn
data-field="Task_Status"
caption="Status"
/>
</DxDataGrid>
</div>
</template>
<script>
import {
DxColumn,
DxDataGrid
} from 'devextreme-vue/data-grid';
import { DxSelectBox } from 'devextreme-vue';
import 'devextreme/data/odata/store';
export default {
components: {
DxSelectBox,
DxColumn,
DxDataGrid
},
data() {
return {
dataSource: {
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'
]
},
statuses: ['All', 'Not Started', 'In Progress', 'Need Assistance', 'Deferred', 'Completed'],
dataGridRefName: 'dataGrid',
};
},
methods: {
onValueChanged({ value }) {
const dataGrid = this.$refs[this.dataGridRefName].instance;
if (value === 'All') {
dataGrid.clearFilter();
}
else {
dataGrid.filter(['Task_Status', '=', value]);
}
}
}
};
</script>
<style scoped>
.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;
}
</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/19.2.5/css/dx.common.css" />
<link rel="stylesheet" type="text/css" href="https://cdn3.devexpress.com/jslib/19.2.5/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',
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@19.2',
'devextreme-vue': 'npm:devextreme-vue@19.2',
jszip: 'npm:jszip@3.1.3/dist/jszip.min.js',
'quill': 'npm:quill@1.3.7/dist/quill.js',
'devexpress-diagram': 'npm:devexpress-diagram',
'devexpress-gantt': 'npm:devexpress-gantt',
'plugin-babel': 'npm:systemjs-plugin-babel@0/plugin-babel.js',
'systemjs-babel-build':
'npm:systemjs-plugin-babel@0/systemjs-babel-browser.js'
},
meta: {
'*.vue': { loader: 'vue-loader' }
},
packages: {
'devextreme-vue': {
main: 'index.js'
},
'devextreme': {
defaultExtension: 'js'
}
},
babelOptions: {
sourceMaps: false,
stage0: true
}
});