This is a migrated thread and some comments may be shown as answers.

Filter in grid doesn't work for me in most of cases

1 Answer 23 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Eldad
Top achievements
Rank 1
Eldad asked on 06 Aug 2015, 10:55 AM

I have a grid. The filtring is working in some cases like a subcompany but doesn't work in almost all other. This is a code:

 

<!DOCTYPE html> <html> <head> <base href="http://demos.telerik.com/kendo-ui/grid/angular"> <style>html { font-size: 14px; font-family: Arial, Helvetica, sans-serif; }</style> <title></title> <link rel="stylesheet" href="//kendo.cdn.telerik.com/2015.2.805/styles/kendo.common.min.css" /> <link rel="stylesheet" href="//kendo.cdn.telerik.com/2015.2.805/styles/kendo.default.min.css" /> <script src="//kendo.cdn.telerik.com/2015.2.805/js/jquery.min.js"></script> <script src="//kendo.cdn.telerik.com/2015.2.805/js/angular.min.js"></script> <script src="//kendo.cdn.telerik.com/2015.2.805/js/kendo.all.min.js"></script> </head> <body> <div id="example" ng-app="KendoDemos"> <div ng-controller="MyCtrl"> <div kendo-grid="grid2" k-options="gridOptions" k-rebind="gridOptions" id="grid" k-on-change="handleChange(data, dataItem, columns)" k-selectable="true"> </div> </div> </div> <script> var subscriberslistItems=[{"monthlyDBID":1603,"monthlyID":"","parkDBID":2,"companyDBID":34,"companyID":"","companyName":"Prima","subCompanyDBID":10,"subCompanyID":"","subCompanyName":"Company1","firstName":"John","lastName":"Meffey","badge":38220010,"curLocation":"52","curLocationDescription":"Out","idNum":"19294","jobTitleID":4,"jobTitleDescription":"Developer","groupID":0,"groupDescription":"","categoryID":4,"categoryDescription":"Desc1","accessProfileID":1,"accessProfileDescription":"Profile 1","monthlyType":2,"monthlyTypeDescription":"Standard","priceTableID":0,"carPlate1":"6523562","carPlate2":"","carPlate3":"","carPlate4":"","carPlate5":"","address":"","phone":"09-7990151","city":"","area":"","zipCode":"","mobile":"050-4224606","fax":"","email":"ayaa10@gmail.com","parkingSpot":"","validFromDate":366854400,"validToDate":505008000,"recordIndex":1},{"monthlyDBID":1622,"monthlyID":"","parkDBID":2,"companyDBID":34,"companyID":"","companyName":"Company 2","subCompanyDBID":10,"subCompanyID":"","subCompanyName":"Child Company 2","firstName":"Tim","lastName":"Tompson","badge":38220000,"curLocation":"52","curLocationDescription":"Out","idNum":"19180","jobTitleID":4,"jobTitleDescription":"Driver","groupID":0,"groupDescription":"","categoryID":4,"categoryDescription":"Category 3","accessProfileID":1,"accessProfileDescription":"Profile 2","monthlyType":2,"monthlyTypeDescription":"Standard","priceTableID":0,"carPlate1":"8044472","carPlate2":"","carPlate3":"","carPlate4":"","carPlate5":"","address":"","phone":"03-5666555","city":"","area":"","zipCode":"","mobile":"052-3233373","fax":"","email":"","parkingSpot":"","validFromDate":368064000,"validToDate":505008000,"recordIndex":2},{"monthlyDBID":1604,"monthlyID":"","parkDBID":2,"companyDBID":34,"companyID":"","companyName":"Company 3","subCompanyDBID":10,"subCompanyID":"","subCompanyName":"Child 1","firstName":"Tim","lastName":"Tompson","badge":38220029,"curLocation":"52","curLocationDescription":"Out","idNum":"8177","jobTitleID":4,"jobTitleDescription":"Driver","groupID":0,"groupDescription":"","categoryID":4,"categoryDescription":"Category 7","accessProfileID":1,"accessProfileDescription":"Profile 5","monthlyType":2,"monthlyTypeDescription":"Standard","priceTableID":0,"carPlate1":"5219217","carPlate2":"","carPlate3":"","carPlate4":"","carPlate5":"","address":"","phone":"","city":"","area":"","zipCode":"","mobile":"050-6996801","fax":"","email":"nave@polfin-ins.co.il","parkingSpot":"","validFromDate":366854400,"validToDate":505008000,"recordIndex":3},{"monthlyDBID":1605,"monthlyID":"","parkDBID":2,"companyDBID":34,"companyID":"","companyName":"Company 7","subCompanyDBID":10,"subCompanyID":"","subCompanyName":"Child 7","firstName":"Hanna","lastName":"Lim","badge":38210651,"curLocation":"52","curLocationDescription":"Out","idNum":"19597","jobTitleID":4,"jobTitleDescription":"Software Developer","groupID":13,"groupDescription":"group 5","categoryID":4,"categoryDescription":"category 1","accessProfileID":4,"accessProfileDescription":"Profile 3","monthlyType":2,"monthlyTypeDescription":"Standard","priceTableID":0,"carPlate1":"8959159","carPlate2":"","carPlate3":"","carPlate4":"","carPlate5":"","address":"","phone":"03-5168855","city":"","area":"","zipCode":"","mobile":"054-3001178","fax":"","email":"hana@orel","parkingSpot":"","validFromDate":366854400,"validToDate":505008000,"recordIndex":4},{"monthlyDBID":1606,"monthlyID":"","parkDBID":2,"companyDBID":34,"companyID":"","companyName":"Company 10","subCompanyDBID":12,"subCompanyID":"","subCompanyName":"Child 1-2","firstName":"Martin×™","lastName":"Shepard","badge":38220034,"curLocation":"52","curLocationDescription":"Out","idNum":"2197","jobTitleID":4,"jobTitleDescription":"Developer","groupID":0,"groupDescription":"","categoryID":4,"categoryDescription":"Category 7","accessProfileID":1,"accessProfileDescription":"Profile 5","monthlyType":2,"monthlyTypeDescription":"Standard","priceTableID":0,"carPlate1":"6260067","carPlate2":"","carPlate3":"","carPlate4":"","carPlate5":"","address":"","phone":"03-6257147","city":"","area":"","zipCode":"","mobile":"050-6828838","fax":"","email":"tzahim@charisma-ins.co.il","parkingSpot":"","validFromDate":367113600,"validToDate":505008000,"recordIndex":5},{"monthlyDBID":1607,"monthlyID":"","parkDBID":2,"companyDBID":34,"companyID":"","companyName":"Company 8","subCompanyDBID":12,"subCompanyID":"","subCompanyName":"Child 4","firstName":"Netanel","lastName":"Black","badge":38220032,"curLocation":"52","curLocationDescription":"Out","idNum":"72481","jobTitleID":4,"jobTitleDescription":"Driver","groupID":0,"groupDescription":"","categoryID":4,"categoryDescription":"Category 7","accessProfileID":1,"accessProfileDescription":"Profile 5","monthlyType":2,"monthlyTypeDescription":"Standard","priceTableID":0,"carPlate1":"1471214","carPlate2":"","carPlate3":"","carPlate4":"","carPlate5":"","address":"","phone":"098840010","city":"","area":"","zipCode":"","mobile":"052-5262333","fax":"","email":"rafizakar@walla.co.il","parkingSpot":"","validFromDate":367113600,"validToDate":505008000,"recordIndex":6},{"monthlyDBID":1608,"monthlyID":"","parkDBID":2,"companyDBID":34,"companyID":"","companyName":"Company 4","subCompanyDBID":10,"subCompanyID":"","subCompanyName":"Child 4","firstName":"Mishael","lastName":"Akerman","badge":38220037,"curLocation":"52","curLocationDescription":"Out","idNum":"313043","jobTitleID":4,"jobTitleDescription":"Driver","groupID":0,"groupDescription":"","categoryID":4,"categoryDescription":"Category 6","accessProfileID":1,"accessProfileDescription":"Profile 4","monthlyType":2,"monthlyTypeDescription":"Standard","priceTableID":0,"carPlate1":"7140229","carPlate2":"","carPlate3":"","carPlate4":"","carPlate5":"","address":"","phone":"09-9514169","city":"","area":"","zipCode":"","mobile":"050-5281348","fax":"","email":"amichel@bezeqint.net","parkingSpot":"","validFromDate":367113600,"validToDate":505008000,"recordIndex":7}]; angular.module("KendoDemos", [ "kendo.directives" ]) .controller("MyCtrl", function($scope){ gridScript = { /* read: companieslistItems,*/ dataSource: { data: subscriberslistItems, pageSize: 10 }, columns: [ {field: "manageName", title: "Name"}, {field: "manageNumber", title: "Number", width: "78px"}, {field: "manageCategoryDescription", title: "Desc",width:"180px"}, {field: "manageProfileAccess", title: "Access", width: "107px"}, {field: "manageParkingSpot", title: "parkingSpot", width: "107px"}, {field: "companyName", title: "CompanyName",width: "107px"}, {field: "subCompanyName", title: "subCompany",width: "107px"}, {field: "curLocationDescription", title: "curLocation", width: "78px"}, {field: "jobTitleDescription", title: "jobTitle", width: "107px"}, {field: "groupDescription", title: "group", width: "107px"}, {field: "idNum", title: "idNum", width: "107px"}, {field: "manageAddress", title: "manageAddress", width: "107px"}, {field: "manageCity", title: "City", width: "107px"}, {field: "manageArea", title: "Area", width: "107px"}, {field: "manageTelephone", title: "Phone", width: "107px"}, {field: "manageCell", title: "cell", width: "107px"}, {field: "manageEmail", title: "Email", width: "147px"} ], rowTemplate: "<tr data-uid='#: uid #' class='hasContextMenu' role='row' data-companyName='#: companyName#'>" + "<td colspan='1' style='text-align: center;' class='statusTemplate'> {{dataItem.firstName}} - {{dataItem.lastName}}</td>" + "<td colspan='1' style='text-align: center;' class='valDiscount'>{{dataItem.badge}}</td>" + "<td colspan='1' style='text-align: center;' >{{dataItem.categoryDescription}}</td>" + "<td colspan='1' style='text-align: center;' >{{dataItem.accessProfileDescription}}</td>" + "<td colspan='1' style='text-align: center;' >{{dataItem.parkingSpot}}</td>" + "<td colspan='1' style='text-align: center;' class='valCompany'>#: companyName#</td>" + "<td colspan='1' style='text-align: center;' class='valSubCompany'>{{dataItem.subCompanyName}}</td>" + "<td colspan='1' style='text-align: center;' >{{dataItem.curLocationDescription}}</td>" + "<td colspan='1' style='text-align: center;' >{{dataItem.jobTitleDescription}}</td>" + "<td colspan='1' style='text-align: center;' >{{dataItem.groupDescription}}</td>" + "<td colspan='1' style='text-align: center;' >{{dataItem.idNum}}</td>" + "<td colspan='1' style='text-align: center;' >{{dataItem.address}}</td>" + "<td colspan='1' style='text-align: center;' >{{dataItem.city}}</td>" + "<td colspan='1' style='text-align: center;' >{{dataItem.area}}</td>" + "<td colspan='1' style='text-align: center;' >{{dataItem.phone}}</td>" + "<td colspan='1' style='text-align: center;' >{{dataItem.mobile}}</td>" + "<td colspan='1' style='text-align: center;' >{{dataItem.email}}</td>" + "</tr>", filterable: true }; $scope.gridOptions = gridScript; }) </script> </body> </html>

 

Does somebody know why? Please, look at attached code.

 

Thanks!

1 Answer, 1 is accepted

Sort by
0
Boyan Dimitrov
Telerik team
answered on 10 Aug 2015, 07:25 AM

Hello Erez,

 

I noticed that rowTemplate is used in order to customize the appearance of the text displayed in each row. Please note that the filtering is handled against the original data and the rowTemplate is used only to customize how the data is displayed. 

 

Regards,
Boyan Dimitrov
Telerik
 
Join us on our journey to create the world's most complete HTML 5 UI Framework - download Kendo UI now!
 
Tags
Grid
Asked by
Eldad
Top achievements
Rank 1
Answers by
Boyan Dimitrov
Telerik team
Share this question
or