..and to give you some context here is the problem that I am trying to solve by setting the IsDirty cell value:

My child band has several columns but only one editable column, which is a checkbox column. When the user ticks the box and clicks a save button on the page the cell is still in edit mode so the new value is not saved.

I was running the grid in row edit mode but they kept forgetting to click the "Done" button so changes were not saved. I have switched to cell edit mode which gets rid of the "Done" button but not the problem.

I can use setCellValue to set the value of a hidden cell (IsDirty) which updates the UI by changing the row to italics. The row is then included in the save processing (ie the grid's transactions). This works fine with iGrid but I can't figure out how to do it with a child band in a hierarchical grid.

The 13.2 sample has the same problem:

http://www.igniteui.com/hierarchical-grid/editing-dataset

If you edit a cell in the product (ie child) band and then click the save button the row is not updated. If instead you click in another cell instead of clicking the save button the row text turns italic. If you then click the save button the change is processed and the row goes back to normal styling.

Hello Graeme,

You should be able to get the collection of rendered layouts by using the "allChildren" API function of igHierarchicalGrid.

var bands = $("#TimesheetGrid").igHierarchicalGrid("allChildren");

Then you can proceed with calling "setCellValue" for the one that's being edited. The "isEditing" igGridUpdating function will help you with this. You can also try calling "endEdit" before "saveChanges" instead of your current implementation to ensure the latest value is saved.

The solution will look similar to the following:

bands.map(function () {

    var band = $(this);

    if (band.igGridUpdating("isEditing")) {

        band.igGridUpdating("endEdit", true); // passing "true" forces endEdit to update the grid

    }

});

$("#TimesheetGrid").igHierarchicalGrid("saveChanges");

I hope this helps! Please, let me know if you have any other questions or concerns!

Best regards,

Stamen Stoychev

Hi

Thanks very much for your answer - it was bang on. I just had to add a little bit to do the same job on teh parent band and now all my changes are being saved.

For completeness, here is the entire save button function :

$("#saveChanges").bind({click: function (e) {
   var oBands = $("#TimesheetGrid").igHierarchicalGrid("allChildren");
   oBands.map(function () {
   var band = $(this);
   if (band.igGridUpdating("isEditing")) {
      band.igGridUpdating("endEdit", true); // passing "true" forces endEdit to update the grid
   }
 });
if ($("#TimesheetGrid").igGridUpdating("isEditing")) {
   $("#TimesheetGrid").igGridUpdating("endEdit", true); // passing "true" forces endEdit to update the grid
}
$("#TimesheetGrid").igHierarchicalGrid("saveChanges");
$.ajax({ url: "", type: "GET", cache: false, async: false });
}
});

Thanks again for the spot on reply,

Graeme