Grid persistence in database

[Tomasz]

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?

grid.setProperties({

       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.

[Rajapandiyan Settu]

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.

Regards,

Rajapandiyan S