jQuery UI Widgets Forums Grid Bug in checkedlist filter

This topic contains 4 replies, has 2 voices, and was last updated by  SharpNoiZy 8 years, 10 months ago.

Viewing 5 posts - 1 through 5 (of 5 total)
  • Author
  • Bug in checkedlist filter #74172

    SharpNoiZy
    Participant

    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!

    Without filterbox

    With filterbox

    Kind regards

    • This topic was modified 8 years, 10 months ago by  SharpNoiZy.
    • This topic was modified 8 years, 10 months ago by  SharpNoiZy.
    • This topic was modified 8 years, 10 months ago by  SharpNoiZy.
    Bug in checkedlist filter #74178

    Dimitar
    Participant

    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,
    Dimitar

    jQWidgets team
    http://www.jqwidgets.com/

    Bug in checkedlist filter #74209

    SharpNoiZy
    Participant

    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

    • This reply was modified 8 years, 10 months ago by  SharpNoiZy.
    Bug in checkedlist filter #74214

    Dimitar
    Participant

    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,
    Dimitar

    jQWidgets team
    http://www.jqwidgets.com/

    Bug in checkedlist filter #74216

    SharpNoiZy
    Participant

    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.

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic.