[SharpNoiZyParticipant]

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.

[SharpNoiZyParticipant]

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

[Author]

Posts