Many times we have requirements to read sub grid records and do subtotal or some others stuff with grid data. Here is same code to retrieve entire rows and columns from SubGrid.
function RetrieveSubGridRecords() {
if (document.getElementById("SubGridName")) {
var grid = document.getElementById("SubGridName").control;
for (var rowNo = 0; rowNo < grid.GetRecordsFromInnerGrid().length; rowNo++)
for (var cellNo = 0; cellNo < grid.GetRecordsFromInnerGrid()[rowNo][3].cells.length; cellNo++)
alert(grid.GetRecordsFromInnerGrid()[rowNo][3].cells[cellNo].outerText);
}
else {
setTimeout("RetrieveSubGridRecords();", 2500);
}
}
function ReadSelectedSubGridRecords() {
if (document.getElementById("SubGridName")) {
var grid = document.getElementById("SubGridName").control;
for (var row = 0; row < grid.get_selectedRecords().length; row++)
alert(grid.get_selectedRecords()[row].Name);
}
}
Read sub-Grid cell value in MS CRM 2013 using Javascript.
function GetSubGridCellValues() {
if (document.getElementById("SubGridName")) {
var grid = document.getElementById("SubGridName").control;
var ids = gridControl.get_allRecordIds();
for (i = 0; i < ids.length; i++) {
alert(gridControl.getCellValue('fullname', ids[i]));
}
}
else {
setTimeout("GetSubGridCellValues();", 2500);
}
}
for more info please follow this BLOG
No comments:
Post a Comment