We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date
close icon

Grid persistence in database

Hi all,

I made grid state save and restore from database based on this article: https://www.syncfusion.com/forums/145592/save-grid-state-column-visibility-filtering-sorting-in-database and everything works well but columns with foreign keys shows text based on foreignKeyField not foreignKeyValue. When I remove restoring columns visibility and reordering foreignkeys columns works again. Could you tell me why that happens?


       filterSettings: persistenceData.filterSettings,

       sortSettings: { columns: persistenceData.sortSettings.columns },

       columns: persistenceData.columns // when I remove this everithing foreign key columns works again

}, false);

Any help would be appreciated. Thank you.

1 Reply

RS Rajapandiyan Settu Syncfusion Team October 26, 2022 08:22 AM

Hi Tomasz,

Thanks for contacting Syncfusion support.

Before proceeding with your query, kindly share the below details to validate further.

  1. Share the complete Grid code file and Grid script version.
  2. Share the video demo of the issue (with restoring the column & without restoring the column).
  3. When you restore the settings to the Grid? share the code details.
  4. Share the replication procedure of the issue.
  5. If possible, share a simple issue reproducible sample.


Rajapandiyan S

Live Chat Icon For mobile
Up arrow icon