过滤器用于整数值搜索kendo ui网格过滤器中的所有列 [英] filter for interger value search all columns in kendo ui grid filter

问题描述

过滤interger值搜索kendo ui网格过滤器中的所有列



这是样本，





我希望过滤UnitPrice和ProductID





//更改活动





$（＃category）。keyup（function（）{

var selecteditem = $（'#category'）。val（）;

var kgrid = $（＃grid）。data（kendoGrid）;

selecteditem = selecteditem.toUpperCase（）;

var selectedArray = selecteditem.split（）;

if（selecteditem）{

} ）;

var orfilter = {logic：或，filters：[]};

var andfilter = {logic：and，filters：[]};

$ .each（selectedArray，function（i，v）{

if（v.trim（）==）{

}

否则{

$ .each（selectedArray，function（i，v1）{

if（v1.trim（）==）{

}

else {

orfilter.filters.push（{field：ProductName，operator：contains，value：v1}，

{field：QuantityPerUnit，operator：contains，value：v1}）;

andfilter.filters.push（orfilter）;

orfilter = {逻辑：或，过滤器：[]};

}



}）;

}

}）;

kgrid.dataSource.filter（andfilter）;

}

else {

kgrid.dataSource.f ilter（{}）;

}



}）;



















[1]：http：//jsfiddle.net/Naka3/38/

filter for interger value search all columns in kendo ui grid filter

This is the sample,


I WANT FILTER FOR "UnitPrice" AND "ProductID"


//change event


$("#category").keyup(function () {
var selecteditem = $('#category').val();
var kgrid = $("#grid").data("kendoGrid");
selecteditem = selecteditem.toUpperCase();
var selectedArray = selecteditem.split(" ");
if (selecteditem) {
});
var orfilter = { logic: "or", filters: [] };
var andfilter = { logic: "and", filters: [] };
$.each(selectedArray, function (i, v) {
if (v.trim() == "") {
}
else {
$.each(selectedArray, function (i, v1) {
if (v1.trim() == "") {
}
else {
orfilter.filters.push({ field: "ProductName", operator: "contains", value:v1 },
{ field: "QuantityPerUnit", operator: "contains", value:v1});
andfilter.filters.push(orfilter);
orfilter = { logic: "or", filters: [] };
}

});
}
});
kgrid.dataSource.filter(andfilter);
}
else {
kgrid.dataSource.filter({});
}

});









[1]: http://jsfiddle.net/Naka3/38/

推荐答案

（＃ category）。keyup（function（）{

var selecteditem =

("#category").keyup(function () {
var selecteditem =

（'#category'）。val（）;

var kgrid =

('#category').val();
var kgrid =

（＃grid）。data（kendoGrid）;

selecteditem = selecteditem.toUpperCase（）;

var selectedArray = selecteditem.split（）;

if（selecteditem）{

}）;

var orfilter = {逻辑：或，过滤器：[]};

var andfilter = {logic：and，filters：[]};

("#grid").data("kendoGrid");
selecteditem = selecteditem.toUpperCase();
var selectedArray = selecteditem.split(" ");
if (selecteditem) {
});
var orfilter = { logic: "or", filters: [] };
var andfilter = { logic: "and", filters: [] };

这篇关于过滤器用于整数值搜索kendo ui网格过滤器中的所有列的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！