Hi Petar, thank you for your help. Now I am able to get child transactions. I did other testing to see what happens:

var hierarchicalGridChildren = $("#MyGrid").igHierarchicalGrid("allChildren");

var transLevel4 = hierarchicalGridChildren.igGrid("transactionsAsString");
var transLevel3 = JSON.stringify(hierarchicalGridChildren.igGrid("pendingTransactions"));
var transLevel2 = JSON.stringify(hierarchicalGridChildren.igGrid("allTransactions"));
var transLevel1 = JSON.stringify($("#MyGrid").igGrid("allTransactions"));

I modified rowId 1, added rowId 5, and deleted rowId 4. Look the result of this at the image below (debug).

As you can see transLevel4 and transLevel2 have the same result (in this case transLevel4 and transLevel3 has nothing to do with the real level in the grid, it is just a name). Now I realize why transLevel3 is empty: there are no pending transactions because I am using AutoCommit(true). transLevel1 is empty because I didn't edit any parent row. Another interesting thing is that using stringify or transactionsAsString has the same effect. (Question 1) Does transactionsAsString use stringify behind the scene?

Regarding to iggridupdatingrowadded I have an issue: setting AutoCommit(false), new child rows are lost after pressing enter on the new row.

(Question 2) How to fix that?

And one more thing. I realized that new child rows inherit the parent's Id if the parent is not new, but when you add a new parent their children don't inherit the parent's Id. (Question 3) How to get the parent's Id and set the child's foreignkey?

Well, I found the best solution till now: make your own aggregated transaction log :) When I finish it I would like to share it here.

Hello Luis,

To answer your questions:

- Yes, transactionsAsString basically calls JSON.stringify before returning the transaction log.

- I think the reason is that the event handler posted by Petar is meant to work on a flat grid. In the hierachical scenario to commit the changes coming from the grid that has thrown the "rowAdded" event you need to do something like this:

$(document).delegate("#grid1", "iggridupdatingrowadded", function (evt, ui) {
     ui.owner.grid.commit();
});

The difference from Petar's sample code is that he is using a selector that returns the parent table and calls commit on it. My sample uses the event args to get a reference to the grid that has a row added and call commit on it directly. Due to the event bubbling the "rowAdded" of each child grid will get captured by a handler attached to the parent one.

- As for the third question, I managed to reproduce what you reported and I am currently doing some further research on what's causing the foreignKeys to not get populated for child rows created for a new parent row. I should be able to provide you with a workaround for the issue a bit later today.

Best regards,

Stamen Stoychev

Thank you so much Stamen! I'll be waiting anxiously for your answer. ;)

Hello Luis,

The reason the foreign key is not automatically set for this case is that the data source of the child grid contains no records initially. Updating can only check for the foreign key within the records it sees and at the moment there is no communication built-in for the feature to ask parents for this information. We'll discuss internally whether or not such functionality should be implemented so we can cover the use-case. If such decision is made I'll create an internal work item and link it to the case created for this forums post. In this way you'll get notified once the implementation is available.

In the meantime you can use the workaround I've prepared. The idea behind it is to use the id of the child grid to extract the foreign key from it. It's not the cleanest solution but it's the shortest one by far, any other requiring traversing the hierarchical structure and identifying whose child the grid throwing the event is. The extracted key is then added to the row object "rowAdding" passes as an event argument. To keep the event binding consistent with your other code it would look something like this:

            $(document).delegate("#grid1", "iggridupdatingrowadding", function (evt, ui) {
                var id = ui.owner.grid.id(),
                    match = id.match(/_([-0-9]*)_/),
                    fk = match && match.length === 2 ? parseInt(match[1], 10) : null;
                if (fk !== null && ui.owner.grid.options.foreignKey) {
                    ui.values[ui.owner.grid.options.foreignKey] = fk;
                }
            });

Please, have in mind that the regex used may need to be modified if you are using anything other than numbers (positive or negative) as PKs. You'll have to ensure it works properly for your hierarchical grid.

I am attaching my sample for reference. I hope this helps! Please, let me know if you have any other questions and/or concerns!

Best regards,

Stamen Stoychev

Hi Stamen,

I have a hierarchical grid where I am facing issue for adding rows to child grid with existing rows. I tried your js that you recommended above. Its does insert the foreign key in ui.values,but when the transactions are posted, I dont see it. The "_addrow" function in infragistics.core.js is being hit before "iggridupdatingrowadding" function. So your js is not changing the actual transaction log due to which the inserted foreign key is not posted in transactions. Please advice.