I am trying for the duplication of the selected row in the grid list. However when I try to save the data, only the parent row is being saved sucessfully, while the child row is not getting updated.
Step 1. $("#assetListGrid").igGridUpdating("addRow", row);
The selected row is being sucessfully reflected in the table along with its child entires.
Step 2. var hierarchicalGridChildren = $("#assetListGrid").igHierarchicalGrid("allChildren");
On save I call a function in which I have written the aforementioned code, now in the hierarchicalGridChildren the information for the latest updated is not included.
Would be really glad to hear from your side if i need to do the anything additional.
Hello bhavin,
I'm not sure I understand your scenario and respectively your issue. Could you explain me with more details about what exactly you're trying to do and send me an isolated sample that reproduces your issue along with steps to reproduce it? Waiting for your response.
Regards,
Tsanna
In the image above there is a duplicate button. When I click on it the row gets duplicated. Now when i save this entire record, the duplicated row is saved but its child rows are not saved. The process that I have used to save the records I have already mentioned that in earlier post.
Please note that using the Updating API won't help you duplicate certain parent record along with its child record, since while adding the parent record the child record is still not created. Instead I suggest you to update the data source using insertRow method and passing it a row object which corresponds to the selected one and then call dataBind method. For instance:
function duplicateRecord() { var ds = $("#hierarchicalGrid").data("igGrid").dataSource; var rowsCount = $("#hierarchicalGrid").data("igGrid").rows().length; selectedRecord["ID"] = rowsCount + 1; ds.insertRow(rowsCount + 1, selectedRecord, rowsCount, true); ds.dataBind(); }
The select4edRecord object will be retrieved on rowSelectionChanged event:
rowSelectionChanged: function (evt, ui) { var rowId = ui.row.id; selectedRecord = ui.owner.grid.dataSource.findRecordByKey(rowId); }
Another thing to mention is that the primary key should be unique, so please make sure that it's not duplicated as well.
I'm attaching a sample with similar scenario for your reference. If you have further questions, feel free to contact me.
Tsanna,
Thank-you for the swift reply. Once when I duplicate the records I do the following
var hierarchicalGridChildren = $("#assetListGrid").igHierarchicalGrid("allChildren"); var assetLicenseInfoTransactions = hierarchicalGridChildren.igGrid("allTransactions");
If I insert & bind to the datasource, is there any way that I can get allTranscations or allChildren cause I am checking what are the latest transactions that have been occurred and depending on that information I am accordingly updating the database.
If I get the data from the datasource, using $('#assetListGrid').data('igGrid').dataSource.data(); then i will get the entire set of data.
Best,
Bhavin
Please note that when you call ds.dataBind() method, this will clear all accumulated transactions and will commit them immediately to the datasource. So what I suggest you is to store them in some collection before calling databind(), so that you can use them for other operations. For instance:
function duplicateRecord() { var ds = $("#hierarchicalGrid").data("igGrid").dataSource; var rowsCount = $("#hierarchicalGrid").data("igGrid").rows().length; if(selectedRecord) { selectedRecord["ID"] = rowsCount + 1; ds.insertRow(rowsCount + 1, selectedRecord, rowsCount, true); transactionLog = $("#hierarchicalGrid").igGrid("allTransactions"); ds.dataBind(); } else { alert("Please select a record"); } }
If you have further questions, feel free to contact me.