jQuery UI Widgets › Forums › Grid › Bug in checkedlist filter
Tagged: angular grid, checkedlist, filter, filterable, filteritems, filtertype, grid, jquery grid, jqxgrid, pageable, paging
This topic contains 4 replies, has 2 voices, and was last updated by SharpNoiZy 9 years, 6 months ago.
-
Author
-
Hi I have a problem with the checkedlist filter in the Grid component.
Like you see on the images, there is an empty option added and this is on each filter the same!Kind regards
Hi SharpNoiZy,
We do not experience such an issue when testing the following example: https://www.jseditor.io/?key=filtertype-checkedlist-with-paging. Please make sure you are using the latest version of jQWidgets (3.8.1).
Best Regards,
DimitarjQWidgets team
http://www.jqwidgets.com/I use the latest version!
Here is my Source defintion:
var source = { datatype: "json", datafields: [ { name: 'Id', type: 'string' }, { name: 'Created', type: 'date' }, { name: 'Started', type: 'date' }, { name: 'Ended', type: 'date' }, { name: 'Environment.Name', type: 'string', map: 'Environment' }, { name: 'Project.Customer.Name', type: 'string', map: 'Customer' }, { name: 'Project.Name', type: 'string', map: 'Project' }, { name: 'Project.InputFormat', type: 'string', map: 'InputFormat' }, { name: 'ToBeProcessedKb', type: 'float' }, { name: 'Status', type: 'string' }, ], url: '@Url.Content("~/JobGrid/GetAllJobsForGrid")', id: 'Id', root: 'Rows', beforeprocessing: function (data) { source.totalrecords = data.TotalRows; }, filter: function () { // update the grid and send a request to the server. $("#jobs_grid").jqxGrid('updatebounddata', 'filter'); }, }; var dataAdapter = new $.jqx.dataAdapter(source);
Here is my grid definition:
$("#jobs_grid").jqxGrid( { width: 1330, theme: 'bootstrap', source: dataAdapter, columnsresize: false, showfilterrow: true, virtualmode: true, rendergridrows: function (params) { return params.data; }, pageSize: 15, pagesizeoptions: ['15', '30', '60', '120'], sortable: false, pageable: true, filterable: true, autoheight: true, columns: [ { text: 'Created', dataField: 'Created', filterable: false, cellsformat: 'yyyy-MM-dd HH:mm:ss', cellsalign: 'center', width: 175 }, { text: 'Started', dataField: 'Started', filterable: false, cellsformat: 'yyyy-MM-dd HH:mm:ss', cellsalign: 'center', width: 175 }, { text: 'Ended', dataField: 'Ended', filterable: false, cellsformat: 'yyyy-MM-dd HH:mm:ss', cellsalign: 'center', width: 175 }, { text: 'Environment', dataField: 'Environment.Name', filtertype: 'checkedlist', width: 140 }, { text: 'Customer', dataField: 'Project.Customer.Name', filtertype: 'checkedlist', width: 150 }, { text: 'Project', dataField: 'Project.Name', width: 150 }, { text: 'Input format', dataField: 'Project.InputFormat', filtertype: 'checkedlist', width: 100 }, { text: 'Input size (KB)', dataField: 'ToBeProcessedKb', width: 120, cellsalign: 'right', cellsformat: 'd2' }, { text: 'Status', dataField: 'Status', filtertype: 'checkedlist', cellsalign: 'left', width: 100 } ] });
And here is the response:
{"TotalRows":12,"Rows":[{"Id":12,"Customer":"Alpro","Project":"Inbound","Release":1,"Environment":"Testsystem","InputFormat":"XML","OutputFormat":"CIN_XML","ToBeProcessedKb":292.3047,"Created":"\/Date(1435053679000)\/","Loaded":"\/Date(1435053689000)\/","Started":"\/Date(1435053690000)\/","Ended":"\/Date(1435053692000)\/","Status":"Failed","Restarted":false},{"Id":11,"Customer":"Fox Spain","Project":"Inbound","Release":2,"Environment":"Testsystem","InputFormat":"Zip","OutputFormat":"CIN_XML","ToBeProcessedKb":22.9775,"Created":"\/Date(1434956341000)\/","Loaded":"\/Date(1434956343000)\/","Started":"\/Date(1434956343000)\/","Ended":"\/Date(1434956344000)\/","Status":"Successful","Restarted":false},{"Id":10,"Customer":"Fox Spain","Project":"Inbound","Release":1,"Environment":"Testsystem","InputFormat":"Zip","OutputFormat":"CIN_XML","ToBeProcessedKb":22.9775,"Created":"\/Date(1434954990000)\/","Loaded":"\/Date(1434955001000)\/","Started":"\/Date(1434955001000)\/","Ended":"\/Date(1434955002000)\/","Status":"Successful","Restarted":false},{"Id":9,"Customer":"Fox Spain","Project":"Inbound","Release":1,"Environment":"Testsystem","InputFormat":"Zip","OutputFormat":"CIN_XML","ToBeProcessedKb":22.9775,"Created":"\/Date(1434953414000)\/","Loaded":"\/Date(1434953424000)\/","Started":"\/Date(1434953424000)\/","Ended":"\/Date(1434953427000)\/","Status":"Successful","Restarted":false},{"Id":8,"Customer":"Alpro","Project":"Inbound","Release":1,"Environment":"Testsystem","InputFormat":"XML","OutputFormat":"CIN_XML","ToBeProcessedKb":364.1514,"Created":"\/Date(1434714343000)\/","Loaded":"\/Date(1434714353000)\/","Started":"\/Date(1434714354000)\/","Ended":"\/Date(1434714355000)\/","Status":"Successful","Restarted":false},{"Id":7,"Customer":"FDA","Project":"UDI","Release":1,"Environment":"Testsystem","InputFormat":"CIN_XML","OutputFormat":"CIN_XML","ToBeProcessedKb":16.0518,"Created":"\/Date(1434698198000)\/","Loaded":"\/Date(1434698198000)\/","Started":"\/Date(1434698199000)\/","Ended":"\/Date(1434698199000)\/","Status":"Successful","Restarted":false},{"Id":6,"Customer":"Alpro","Project":"Inbound","Release":1,"Environment":"Testsystem","InputFormat":"XML","OutputFormat":"CIN_XML","ToBeProcessedKb":229.9521,"Created":"\/Date(1434687448000)\/","Loaded":"\/Date(1434687448000)\/","Started":"\/Date(1434687448000)\/","Ended":"\/Date(1434687449000)\/","Status":"Failed","Restarted":false},{"Id":5,"Customer":"Alpro","Project":"Inbound","Release":1,"Environment":"Testsystem","InputFormat":"XML","OutputFormat":"CIN_XML","ToBeProcessedKb":229.9521,"Created":"\/Date(1434687240000)\/","Loaded":"\/Date(1434687241000)\/","Started":"\/Date(1434687241000)\/","Ended":"\/Date(1434687241000)\/","Status":"Failed","Restarted":false},{"Id":4,"Customer":"Fox Spain","Project":"Inbound","Release":1,"Environment":"Testsystem","InputFormat":"Zip","OutputFormat":"CIN_XML","ToBeProcessedKb":2.8477,"Created":"\/Date(1434635528000)\/","Loaded":"\/Date(1434635528000)\/","Started":"\/Date(1434635530000)\/","Ended":"\/Date(1434635531000)\/","Status":"Successful","Restarted":false},{"Id":3,"Customer":"Fox Spain","Project":"Inbound","Release":1,"Environment":"Testsystem","InputFormat":"Zip","OutputFormat":"CIN_XML","ToBeProcessedKb":31.8008,"Created":"\/Date(1434635528000)\/","Loaded":"\/Date(1434635528000)\/","Started":"\/Date(1434635528000)\/","Ended":"\/Date(1434635530000)\/","Status":"Successful","Restarted":false},{"Id":2,"Customer":"Fox Spain","Project":"Inbound","Release":1,"Environment":"Testsystem","InputFormat":"Zip","OutputFormat":"CIN_XML","ToBeProcessedKb":2.8477,"Created":"\/Date(1434632158000)\/","Loaded":"\/Date(1434632158000)\/","Started":"\/Date(1434632160000)\/","Ended":"\/Date(1434632161000)\/","Status":"Successful","Restarted":false},{"Id":1,"Customer":"Fox Spain","Project":"Inbound","Release":1,"Environment":"Testsystem","InputFormat":"Zip","OutputFormat":"CIN_XML","ToBeProcessedKb":31.8008,"Created":"\/Date(1434632158000)\/","Loaded":"\/Date(1434632158000)\/","Started":"\/Date(1434632159000)\/","Ended":"\/Date(1434632160000)\/","Status":"Successful","Restarted":false}]}
Kind regards
Hi SharpNoiZy,
Please try setting the filteritems property of the “Environment” column:
{ text: 'Environment', dataField: 'Environment.Name', filtertype: 'checkedlist', width: 140, filteritems: ['Testsystem'] }
Best Regards,
DimitarjQWidgets team
http://www.jqwidgets.com/Sure, this works, but I don’t know in front which items will arrive in that grid from which environments.
So this “autodiscover feature” of jqGrid is a big win!
But it has this one small bug. ;(I hope you can find it.
-
AuthorPosts
You must be logged in to reply to this topic.