enablePersistence + allowFiltering + foreignKeyField column = error

[Tomasz]

Hi

I have a problem with grid. When I set enablePersistence=true, and allowfiltering=true in the DataGrid, which contains column databinded to foreign DataSet, when user choose some options in column filters, the grid is not loading after refresh of page.

Problem doesn't exist when enablePersistence is set to false, but I need this function.

Here is code:

<ejs-grid enablePersistence="true"
          id="Grid1231231"
          allowFiltering="true"
          locale="pl-PL"
          load="onLoad"
          >
    <e-data-manager url="@Url.Page("./Index", new {handler = "DataSource"})"
                    batchUrl="@Url.Page("./Index", new {handler = "BatchUpdate"})"
                    adaptor="UrlAdaptor">
    e-data-manager>
    <e-grid-filtersettings type="Menu">e-grid-filtersettings>
    <e-grid-editsettings allowAdding="true" allowDeleting="true" allowEditing="true" mode="Batch">e-grid-editsettings>
  <e-grid-columns>
        <e-grid-column field="DispatchListId" type="number" isPrimaryKey="true" isIdentity="true" headerText="ID" textAlign="Center" width="80">e-grid-column>
       <e-grid-column field="DispatchPlaceId" headerText="Miejsce załadunku" dataSource="@Model.PlantViewModels" foreignKeyField="PlantId" foreignKeyValue="Name">e-grid-column>
    e-grid-columns>

And here is the error, after refreshing page, when column is filtered:

Uncaught TypeError: gObj.getColumnByField(...) is undefined

refreshFilteredColsUid https://localhost:5051/lib/syncfusion/ej2.js?v=tOL7GVjRePmK1ryVO6RrPErgrv2DQYaEVvCs7ly4WoI:87692

refreshFilteredCols https://localhost:5051/lib/syncfusion/ej2.js?v=tOL7GVjRePmK1ryVO6RrPErgrv2DQYaEVvCs7ly4WoI:60779

notify https://localhost:5051/lib/syncfusion/ej2.js?v=tOL7GVjRePmK1ryVO6RrPErgrv2DQYaEVvCs7ly4WoI:8557

notify https://localhost:5051/lib/syncfusion/ej2.js?v=tOL7GVjRePmK1ryVO6RrPErgrv2DQYaEVvCs7ly4WoI:2155

render https://localhost:5051/lib/syncfusion/ej2.js?v=tOL7GVjRePmK1ryVO6RrPErgrv2DQYaEVvCs7ly4WoI:81645

appendTo https://localhost:5051/lib/syncfusion/ej2.js?v=tOL7GVjRePmK1ryVO6RrPErgrv2DQYaEVvCs7ly4WoI:2080

https://localhost:5051/Mes/DispatchLists/:515

ej2.js:87692:20

refreshFilteredColsUid https://localhost:5051/lib/syncfusion/ej2.js?v=tOL7GVjRePmK1ryVO6RrPErgrv2DQYaEVvCs7ly4WoI:87692

refreshFilteredCols https://localhost:5051/lib/syncfusion/ej2.js?v=tOL7GVjRePmK1ryVO6RrPErgrv2DQYaEVvCs7ly4WoI:60779

notify https://localhost:5051/lib/syncfusion/ej2.js?v=tOL7GVjRePmK1ryVO6RrPErgrv2DQYaEVvCs7ly4WoI:8557

notify https://localhost:5051/lib/syncfusion/ej2.js?v=tOL7GVjRePmK1ryVO6RrPErgrv2DQYaEVvCs7ly4WoI:2155

render https://localhost:5051/lib/syncfusion/ej2.js?v=tOL7GVjRePmK1ryVO6RrPErgrv2DQYaEVvCs7ly4WoI:81645

appendTo https://localhost:5051/lib/syncfusion/ej2.js?v=tOL7GVjRePmK1ryVO6RrPErgrv2DQYaEVvCs7ly4WoI:2080

https://localhost:5051/Mes/DispatchLists/:515

Is persistence working with foreign data column?

I checked it with version 19.2.0.47 and 19.2.0.59

[Rajapandiyan Settu]

Hi Tomasz,  

  

Thanks for contacting Syncfusion support. 

 

We can reproduce the reported behavior at our end. We have confirmed this is an issue from our side and logged a bug for the same as “Persistence is not working when filtering applied on foreignKey column”. 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 Sep 15^th 2021.  

  

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.   

  

FB Link: https://www.syncfusion.com/feedback/28381/persistence-is-not-working-when-filtering-applied-on-foreignkey-column 

  

Regards,  

Rajapandiyan S  

[Rajapandiyan Settu]

Hi Tomasz, 

Thanks for your patience. 

We are glad to announce that our Essential Javascript2 patch release (v19.2.62) has been rolled out successfully and in that release we have added the fix for “Persistence is not working when filtering applied on foreignKey column” issue. So, please update your package to the current version and use latest style script to get this.  

 

ReleaseNote: https://ej2.syncfusion.com/documentation/release-notes/19.2.62/?type=all#grid 

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 any further assistance. 

Regards, 

Rajapandiyan S