Compare column cell B with column cell A, turn cell value to red if greater

[vnistalaParticipant]

Hello,
I have a grid where I’ve to compare the values from 2 columns if column cell value of B is greater than Cell value of A for that row then turn only the cell of row in column B to red.
I have code snippet which is tuning all the cell values to red, need your help on the same.

var gridAdapter3 = new $.jqx.dataAdapter(sourcegrid3, { async: false, autoBind: true, loadError: function (xhr, status, error) { alert('Error loading "' + source.url + '" : ' + error); } });						
			
			//var statusId = 0; 
			var cellRecords = gridAdapter3.records;
			var length = cellRecords.length;
			for (var i = 0; i < length; i++) {
			var record = cellRecords[i];
			var nsla = Number(record.sla);
			var nresponsetime = Number(record.responsetime);
			console.log(nresponsetime);
			
            var statusSaver = function (row, columnfield, value) {
                statusId = value;				
            }
			
			var cellsrenderer = function (row, columnfield, value, defaulthtml, columnproperties) {
									
			if (nresponsetime > nsla) {		
					return '<span style="margin: 4px;float: ' + columnproperties.cellsalign + ';color: #ff0000;font-weight: bold">' + record.responsetime + '</span>';
                }			
			else
                return '<span style="margin: 4px; margin-right: 10px; font-size: 14px; float: ' + columnproperties.cellsalign + ';">' + value + '</span>';
            }	
			}
			

Any help is appreciated

Regards,
Venkat

[HristoParticipant]

Hello Venkat,

It is not appropriate to set “cellsrenderer” callback in the for loop.
Also, I would suggest you look at this demo:
http://www.jqwidgets.com/jquery-widgets-demo/demos/jqxgrid/gridcellclass.htm?light
Do you receive any error message?
You could check the data that you compare in the “if” statement

Best Regards,
Hristo Hristov

jQWidgets team
http://www.jqwidgets.com

[vnistalaParticipant]

Hello Hristo,
Yes it makes sense, added the same in the grid cellclass.
I saw another example
http://www.jqwidgets.com/community/topic/grig-cell-styling/

var cellclass = function (row, columnfield, value) {
                var QuantityPerUnit = $('#jqxgrid').jqxGrid('getcellvalue', row, "QuantityPerUnit");
                var UnitPrice = $('#jqxgrid').jqxGrid('getcellvalue', row, "UnitPrice");
                if (QuantityPerUnit <= UnitPrice) {
                    return "red";
                };
            }

Followed the same in my code but getting the following error.

Uncaught Error: Invalid Selector – #jqxgrid! Please, check whether the used ID or CSS Class name is correct.
at m.fn.init.a.fn.(anonymous function) [as jqxGrid] (http://10.10.122.84:8080/sample-tabs/jqwidgets/jqxcore.js:7:55680)

Appreciate your help and responses.
Regards,
Venkat

[HristoParticipant]

Hello Venkat,

This error shows when the widget selector is wrong. Please, check it.
Is the same selector “jqxgrid” when try to get value (“getcellvalue”) and the created Grid?

Best Regards,
Hristo Hristov

jQWidgets team
http://www.jqwidgets.com

[vnistalaParticipant]

Hello Hristo,
Yes that’s what the error tells, so when i put jqxgrid in double quotes it worked.
var sla = $("#jqxGrid").jqxGrid('getcellvalue', row, 'sla');

I was trying some cool options from jqwidgets, like when we turn on the filter function in grid the chart should change based on the filter, but for some reason i’m getting blank in chart. Am i missing something.
example:

$("#jqxGrid").on('filter', function () {
                var rows = $("#jqxGrid").jqxGrid('getrows');
                var chart = $(chartContainer7).jqxChart('getInstance');
                chart.source = rows;
                chart.update();
            }); 

I would like to thank and appreciate for all the help provided so far.
Regards,
Venkat

[HristoParticipant]

Hello Venkat,

Could you provide us more details?
I would ask to write topics to the relevant sections (about the Grid in the section of Grid and relevant for the Chart).

Best Regards,
Hristo Hristov

jQWidgets team
http://www.jqwidgets.com

[vnistalaParticipant]

Sure thanks Hristo added a new post in charts section

http://www.jqwidgets.com/community/topic/chart-with-grid-not-working/

Regards,
Venkat

[Author]

Posts