JqxGrid row number due to another column.

[Franco01Participant]

Hi!

I can’t solved the following problem.
I need a row number, which depends on Date column. If Date is not equal than previous Date, than row number start again with 1.

`columns:
[
{
text: “Date”, dataField: “Date”,
columntype: “datetimeinput”,
align: ‘center’,
formatString: “yyyy.MM.dd”,
cellsFormat: ‘yyyy.MM.dd’,
width: 120,
createeditor: function (row, cellvalue, editor) {
editor.jqxDateTimeInput({ culture: “hu-HU”, formatString: “yyyy.MM.dd” });
}
},
{
text: “RowNumber”,
cellsalign: “right”,
sortable: false,
filterable: false,
editable: false,
groupable: false,
draggable: false,
resizable: false,
datafield: “”,
columntype: “number”,
width: 70,
cellsrenderer: function (row, column, value) {
var rownumber;
if (row != 0) {
var prevdate = $(“#jqxgrid”).jqxGrid(“getcelltext”, row – 1, “Date”);
var date = $(“#jqxgrid”).jqxGrid(“getcelltext”, row, “Date”);
if (prevdate == date) {
rownumber= $(“#myForm”).data(“rownumber”);
rownumber= rownumber+ 1;
} else
rownumber= 1;
} else
rownumber= 1;
$(“#myForm”).attr(“data-rownumber”, rownumber);
return “<div style=’margin:4px;’>” + rownumber+ “</div>”;
}
}`

Example
Date RowNumber
2016.04.20 1
2016.04.20 2
2016.04.20 3

My Code works:
Date RowNumber
2016.04.20 1
2016.04.20 2
2016.04.20 2

because in this line, I get 1 in the rownumber variable from myForm data rownumber attribute.
rownumber= $("#myForm").data("rownumber");

[HristoParticipant]

Hello Franco01,

It is simple mistake need to declare out of the Grid initialization and could you try this:

var rownumber = 1;
$("#jqxgrid").jqxGrid(
	{
		...
		columns: [
			{ ... },
			{
				text: "RowNumber",
				...				
				cellsrenderer: function (row, column, value)
				{
					if (row != 0)
					{
						var prevdate = $("#jqxgrid").jqxGrid("getcelltext", row - 1, "Date");
						var date = $("#jqxgrid").jqxGrid("getcelltext", row, "Date");
						// .. add your logic
						if (prevdate == date)
						{
							rownumber += 1;
						} else
						{
							rownumber = 1;
						}
					}

					return "<div style='margin:4px;'>" + rownumber + "</div>";
				}
			}
		]
});

Best Regards,
Hristo Hristov

jQWidgets team
http://www.jqwidgets.com

[Franco01Participant]

Of course! Thank you!:)

[Author]

Posts