Use Range Selection for Filtering
Documentation
The RangeSelector widget allows you to handle changes of the currently selected range. For this purpose, the callback function is specified in the onValueChanged option. This demo illustrates how to use the newly selected range for filtering data.
Feel free to share demo-related thoughts here.
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.
$(function(){
var showEmployees = function(employees) {
var tableHtml;
if ($('#selectedEmployees').length === 0) {
$('#range-selector-demo').append("<center><h2>Selected Employees</h2> <div id='selectedEmployees' /></center>");
}
$('#selectedEmployees').empty();
tableHtml = '<table><tr>';
$.each(['First Name', 'Last Name', 'Birth Year', 'City', 'Title'], function () {
tableHtml += '<td><b>' + this + '</b></td>';
});
tableHtml += '</tr>';
$.each(employees, function () {
tableHtml += '<tr><td>' + this.FirstName + '</td><td>' + this.LastName + '</td><td>' + this.BirthYear + '</td><td>' + this.City + '</td><td>' + this.Title + '</td></tr>';
});
tableHtml += '</table>';
$('#selectedEmployees').html(tableHtml);
};
$("#range-selector-demo").dxRangeSelector({
margin: {
top: 20
},
size: {
height: 140
},
dataSource: employees,
dataSourceField: "BirthYear",
scale: {
tickInterval: 1,
minorTickInterval: 1,
label: {
format: {
type: "decimal"
}
}
},
behavior: {
callValueChanged: "onMoving"
},
title: "Filter Employee List by Birth Year",
onValueChanged: function (e) {
var selectedEmployees = $.grep(employees, function(employee) {
return employee.BirthYear >= e.value[0] && employee.BirthYear <= e.value[1];
});
showEmployees(selectedEmployees);
}
});
showEmployees(employees);
});
<!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.4.1/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.5/css/dx.common.css" />
<link rel="stylesheet" type="text/css" href="https://cdn3.devexpress.com/jslib/19.1.5/css/dx.light.css" />
<script src="https://cdn3.devexpress.com/jslib/19.1.5/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">
<div id="range-selector-demo"></div>
</div>
</body>
</html>
#range-selector-demo {
height: 540px;
width: 100%;
}
#range-selector-demo h2 {
font-size: 20px;
margin: 38px 0 10px;
text-align: center;
}
#range-selector-demo table {
width: 100%;
border: 1px solid #c2c2c2;
border-collapse: collapse;
border-spacing: 0;
}
#range-selector-demo td {
width: 20%;
padding: 4px;
border-top: 1px solid #c2c2c2;
border-bottom: 1px solid #c2c2c2;
}
#range-selector-demo td > b {
font-weight: 500;
}
var employees = [
{ LastName: "Davolio", FirstName: "Nancy", BirthYear: 1948, City: "Seattle", Title: "Sales Representative" },
{ LastName: "Fuller", FirstName: "Andrew", BirthYear: 1952, City: "Tacoma", Title: "Vice President, Sales" },
{ LastName: "Leverling", FirstName: "Janet", BirthYear: 1963, City: "Kirkland", Title: "Sales Representative" },
{ LastName: "Peacock", FirstName: "Margaret", BirthYear: 1937, City: "Redmond", Title: "Sales Representative" },
{ LastName: "Buchanan", FirstName: "Steven", BirthYear: 1955, City: "London", Title: "Sales Manager" },
{ LastName: "Suyama", FirstName: "Michael", BirthYear: 1963, City: "London", Title: "Sales Representative" },
{ LastName: "King", FirstName: "Robert", BirthYear: 1960, City: "London", Title: "Sales Representative" },
{ LastName: "Callahan", FirstName: "Laura", BirthYear: 1958, City: "Seattle", Title: "Inside Sales Coordinator" },
{ LastName: "Dodsworth", FirstName: "Anne", BirthYear: 1966, City: "London", Title: "Sales Representative" }
];