Incorrect record editing (or selection) when grid is grouped and data fetched with CustomDataAdaptor

[Laurin S]

Hi,

I have a grid that is grouped according to a column and the data is obtained via a CustomDataAdaptor. If I want to open a record that is in the 2nd group, for example, by double-clicking on it and edit it in the edit dialogue, the data record I clicked on is not displayed in the dialogue, but a different one. This means that a "wrong"/different record is unknowingly edited.

(Perhaps it should be mentioned that grouping is done on a foreign key column.)

I have created an example to illustrate this: https://stackblitz.com/edit/rnukgz-pbeok3?file=index.ts

The grid is grouped according to the column "EmployeeID" and if I want to open/edit the data record with the ID "10008" by a double-click, the selected one is not opened, but another one (ID = 10003).

Am I doing something wrong or what is the reason for this?

[Aishwarya Rameshbabu]

Hi Laurin S,

Greetings from Syncfusion support.

We have confirmed that the reported behavior is an issue from our side and logged it as “When the foreign key column is grouped, the edit dialog of the selected record does not open properly with those records”. 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 “July 31st, 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/59563/with-the-foreign-key-column-is-grouped-the-edit-dialog-of-the-selected-record-does

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

[Aishwarya Rameshbabu]

Hi Laurin S,

 

We are glad to announce that, we have included the fix for the issue “When the foreign key column is grouped, the edit dialog of the selected record does not open properly with those records” in our 26.2.7 release. So please upgrade to our latest version of the Syncfusion package to resolve the reported issue.

 

Root Cause: The edit dialog for the selected record does not open correctly because it attempts to retrieve the records using currentViewRecords.

 

Solution:  The issue was resolved by establishing a condition to determine the length of the foreign key column. Subsequently, the record to be edited is selected using getRowObjectFromUID rather than getCurrentViewData.

 

Sample: https://stackblitz.com/edit/lpcjgz-ksvc9j?file=index.ts,index.html

  

Release Notes: https://ej2.syncfusion.com/javascript/documentation/release-notes/26.2.7?type=all#grid

 

Feedback: https://www.syncfusion.com/feedback/59563/with-the-foreign-key-column-is-grouped-the-edit-dialog-of-the-selected-record-does

 

We thank you for your support and appreciate your patience in waiting for this release. Please get back to us if you need any further assistance.

 

Regards,

Aishwarya R