UpdateCell method in batch mode

[ThreeGo]

In batch mode, columns set to isPrimaryKey are not editable, but they work as editable in newly added rows.

However, the updateCell method does not work on columns set to isPrimaryKey, even if they are newly added rows.

I think this problem needs to be improved. Can it be done?

[Aishwarya Rameshbabu]

Hi ThreeGo,

Greetings from Syncfusion support.

Query 1: In batch mode, columns set to isPrimaryKey are not editable, but they work as editable in newly added rows:

In Syncfusion Grid's batch editing mode, columns designated as primary keys are typically non-editable because primary keys uniquely identify records and remains unaltered. However, for newly added rows, the grid permits the setting of primary key values since the new record does not yet exist in the dataset. Once saved to the Grid's dataSource, these primary key values cannot be edited.

Query 2: However, the updateCell method does not work on columns set to isPrimaryKey, even if they are newly added rows:

The ‘updateCell’ method in the Grid is used to update the specified cell by a given value, which also does not allow updating the value of the primary key column in the case of editing. However, when adding a new record in batch mode, it should permit changes to all fields, including the primary key. Presently, this method does not allow alterations to the primary key value. We have conformed the reported scenario as a bug from our end and logged it as “UpdateCell method does not change the value of the primary key column in a newly added record before saving in batch mode”.

Thank you for taking the time to report this issue and helping us improve our product. At Syncfusion, we are committed to fixing all validated defects (subject to technical feasibility and Product Development Life Cycle ) and will include the defect fix in our upcoming patch release which will be rolled out on “October 15th, 2024”.

You can now track the current status of your request, review the proposed resolution timeline, and contact us for any further inquiries through the below link,

Feedback: https://www.syncfusion.com/feedback/61665/updatecell-method-does-not-change-the-value-of-the-primary-key-column-in-a-newly

Disclaimer: "Inclusion of this solution in the weekly release may change due to other factors including but not limited to QA checks and works reprioritization".

Regards

Aishwarya R                                                                                                                                                                            

[ThreeGo]

Thank you for your support. 

We look forward to your next release.

[Sivaranjani Rajasekaran]

Hi ThreeGo,

We are glad to announce that, we have included the fix for the issue “UpdateCell method does not change the value of the primary key column in a newly added record before saving in batch mode.” in our 27.1.53 release. So please upgrade to our latest version of the Syncfusion package to resolve the reported issue.

 

Root Cause: The UpdateCell method failed to update the primary key for newly added records in batch mode.

Solution: The issue was resolved by addressing the handling of newly added records, allowing the UpdateCell method to update the primary key before batch saving.

Feedback link : https://www.syncfusion.com/feedback/61665/updatecell-method-does-not-change-the-value-of-the-primary-key-column-in-a-newly

Sample Link : https://stackblitz.com/edit/angular-zyk2ns-i9mvgl?file=src%2Fapp.component.ts

We thank you for your support and appreciate your patience in waiting for this release. Please get in touch with us if you would require further assistance.

 

Regards,

Sivaranjani R.