Updated Value saved but not displayed during Batch Edit with Remote Data

Question

I'm using DataGrid with batch editing to CRUD data from a remote API using OData. All operations and displays for regular columns work great, however, I have a GridForeignColumn that binds an ID from my grid and makes another OData call to retrieve that ID from another Database and supplies value. When I start Batch editing, all the possible values show up in the drop down, but once I select a value, it will save but not display. Only showing blank text as seen below. This is my code for the Forgein Grid: I have to press update and save for text of the value shows back up. What could I be doing wrong? I also have a sample file provided. Best.Attachment: SampleFileForIssue_1000bd5.zip

Vignesh Natarajan · Accepted Answer

Hi Oscar,  
 
Thanks for contacting Syncfusion support.  
 
Query: “but once I select a value, it will save but not display. Only showing blank text as seen below.” 
 
We have validated the reported issue by preparing a sample as per your suggestion and we are able to reproduce the reported issue at our end while using Syncfusion.Blazor Nuget below 19.1.0.56. We would like to inform you that we have resolved the reported issue in our 19.1.0.57 release. So we request you to upgrade to our latest version to resolve the reported issue.  
 
Please find the Nuget package and release notes regarding the sample from below  
 
https://www.nuget.org/packages/Syncfusion.Blazor/ 
https://blazor.syncfusion.com/documentation/release-notes/19.1.57/?type=all#grid 
 
Please get back to us if you have further queries.  
 
Regards, 
Vignesh Natarajan

Oscar Lee · Answer

Hi Vignesh,

Thanks for getting back to me. I have updated the nuget package to 19.1.0.57 and am still encountering this issue. Were you able to get it fixed on your end?

If it helps, I can further elaborate on where I think the issue is coming from. I'm using paging on my grid because I have a database with over 100,000 entries. Thus, the grid only loads the first 50 items from the Db. Lets say that these first 50 results all have a language of Portuguese, and I want to change one to be English. That entry's language column, which I have change to English, will not show up. Now, I save. The grid now has entries with both Portuguese and English. When I go change a different entry to English, the update will actually show when I hit enter, because English is already on the grid. In short, this issue only occurs when a language not yet seen on the grid is selected. Example below.

Any thoughts?

Best, Oscar

Vignesh Natarajan · Answer

Hi Oscar, 

Thanks for the detailed explanation.     
 
Query: “In short, this issue only occurs when a language not yet seen on the grid is selected.” 

We have analyzed the reported issue and we are able to reproduce the reported issue at our end also. We have confirmed the reported query as a bug and logged the defect report “SelectedValue is not displayed in ForeignKey column while perform batch editing” for the same. 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 technological feasibility and Product Development Life Cycle ) and including the defect fix in our weekly release which is expected to be rolled out by end of May 2021. We will update you once the release is rolled out.    
       
You can now track the current status of your request, review the proposed resolution timeline, and contact us for any further inquiries through this link.       
   
https://www.syncfusion.com/feedback/24744/selectedvalue-is-not-displayed-in-foreignkey-column-while-perform-batch-editing  
 
Till then we appreciate your patience.   
 
Regards, 
Vignesh Natarajan