Grid does not automatically refresh after saving

[Craig]

Hi,

I have a quite a complex Grid that after saving or deleting does not update. I can resolve the problem by force refreshing the Grid after delete and save see:

 actionComplete: (e) => {

                    if (e.requestType == 'save' || e.requestType == 'delete') {

                        DataGrid.refresh();

                    }

                }, 

However, this then hits the database twice. Why does the grid not refresh automatically? (all my other ones do)

I have attached the code for for the initialisation of of the grid

Thanks

Craig

Attachment: code_3aac96d.zip

[Madhu Sudhanan P]

Hi Craig, 

Thanks for contacting Syncfusion support. 

We must need to return the edited values from server to Grid. Then only the edited values will be reflected in Grid after complete the Add and Update action. So, please ensure whether the edited values are properly returned from the server in your project. We have prepared the sample based on your requirement from your reference and you can download that sample from the below link, 

Sample: http://www.syncfusion.com/downloads/support/directtrac/general/ze/EJGrid1316075379.zip 

In this sample we have returned the edited values from the server while performing Add and Update action. But we do not need to return the value while perform the delete action. Please refer the following code snippet, 

public HttpResponseMessage Patch([FromODataUri]int key, [FromBody]Orders entity) 

  { 

             

           ... 

 

       return Request.CreateResponse(HttpStatusCode.OK, data); 

  } 

public HttpResponseMessage Post(Orders value) 

  { 

           ... 

 

       return Request.CreateResponse(HttpStatusCode.OK, value); 

  } 

Still If you facing the sample issue, please share the following details for further assistance, 

1)      Share your controller code snippet (i.e you have used to perform the CRUD action). 

2)      Share the network tab response. 

3)      Syncfusion package version. 

Regards, 

Madhu Sudhanan P 

[Craig]

Hi,

I have looked at the code and it resolve the issue.

I am using a vanilla implementation of the OData 4 implementation for .NET. I have around 20 Odata controllers all structured the same way as attached and only on this one does it not work (all the return HTTP codes are correct). 

See video for the implementation: http://www.youtube.com/watch?v=Iw-vO8qRBQg

You will see in the video that the POST, PATCH OR DELETE command executes and returns correctly. The datagrid then gets new data but does not update. If I add in the manual refresh, it just calls the GET method for all the data again, just a few milliseconds afterwards.

I have attached the full source for the HTML and ODATA classes for your reference.

Regards,

Craig

Attachment: Files_af774647.zip

[Madhu Sudhanan P]

Hi Craig, 

Thanks for your update. 

We suspect that this error might occur in the old versions. Could you please provide the grid source (ej2.min.js) version it will helpful for us to analyze further or you can also upgrade to the latest version to give it a try whether it might resolve the reported problem. 

https://ej2.syncfusion.com/documentation/release-notes/index/  

Regards, 

Madhu Sudhanan P  

[Craig]

Hi,

See attached

Thanks

Craig

Attachment: ej2.min.js_3b3e8dc.zip

[Thavasianand Sankaranarayanan]

Hi Craig, 

Thanks for your update. 

Could you please share the Syncfusion nuget package version (we are not able to find out the version from ej2.min.js file.) or we request you to upgrade your packages this might resolve your problem. 

Latest Nuget package version: https://www.nuget.org/packages/Syncfusion.EJ2.Javascript/17.1.0.32-beta  

Regards, 

Thavasianand S. 

[Craig]

The nuget version is 16.4.0.42

[Craig]

I have upgraded to 16.4.0.54 and the issue still remains.

I wonder whether it is a timing issue as the call gets made bu the Grid does not update

[Madhu Sudhanan P]

Hi Craig, 

Thanks for your update. 

In your application, you are enabling virtualization(mainly for large amount of data) in Grid but you are binding lower amount of data(2) so could you please confirm whether do you want to use virtualization feature in Grid? 

If this does not necessary then we suggest you to disable the virtualization and columnVirtualization feature in Grid and try again once this might solve the problem. 

Regards, 

Madhu Sudhanan P 

[Craig]

Hi,

Where am I enabling virtualization and how can it be switched off? I have made a conscious decision to use it as this grid will not hold massive amounts of data

Craig

[Thavasianand Sankaranarayanan]

Hi Craig, 

Thanks for your update. 

 

Query: Where am I enabling virtualization and how can it be switched off? I have made a conscious decision to use it as this grid will not hold massive amounts of data 

 

We have checked your query and you can disable the virtualization feature by setting the enableVirtualization property as false. Please refer the below code example. 

[Index.cshtml] 

var DataGrid = new ej.grids.Grid({ 

                dataSource: DataManager, 

                query: new ej.data.Query().where('Deleted', 'equal', false), 

                editSettings: { allowEditing: true, allowAdding: true, allowDeleting: true, mode: 'Normal', newRowPosition: 'Top' }, 

                allowPaging: true, 

                height: 410, 

                width: 'auto', 

                allowResizing: true, 

                enableVirtualization: false, 

                enableColumnVirtualization: false, 

                pageSettings: { pageCount: 4, pageSize: 50 }, 

                toolbar: ['Add', 'Edit', 'Delete', 'Update', 'Cancel'], 

Please refer the below documentation for getting better understanding about virtualization and where you can enable it. 

Documentation: https://ej2.syncfusion.com/documentation/grid/virtual/?no-cache=1#limitations-for-virtualization  

Regards, 

Thavasianand S.