Paging for ejGrid not working after first page

[Chris Mack]

I have an ejgrid on a page and the first page shows the proper 25 records, but when I navigate to another page it shows all of the records rather than the selected page.

Here is my grid code. Any assistance would be appreciated.

$('#Grid').ejGrid({
                        dataSource: reportDetails,
                        enableRowHover: true,
                        allowTextWrap: false,
                        allowPaging: true,
                        allowSorting: true,                   
                        allowFiltering: true,
                        allowResizing: false,
                        allowResizeToFit: false,
                        allowKeyboardNavigation: true,
                        allowSearching: true,
                        allowMultipleExporting:true,
                        enablePersistance:true,
                        pageSettings: { pageSize: '25' },
                        filterSettings: { filterType: "excel" },
                        columns: [
                                    { field: "Date", width: 115 },
                                    { field: "Name", width: 120 },
                                    { field: "Product" },
                                    { field: "Variation", width: 120},
                                    { field: "Buy", width: 90},
                                    { field: "Order Status", width: 90 },
                                    { field: "Payment Status", width: 90 },
                                    { field: "Shipping Status", width: 100 },
                                    { field: "Actions", width: 90,allowFiltering:false,allowSorting:false}
                                ]
                        });

[Ragavee U S]

Hi Chris, 

Thanks for your interest in Syncfusion products. 

From your code example, we could see that you have specified the “pageSize” property of the Grid pageSettings as string which is supposed to be an integer value. 

Since the pageSize property is defined as a string value, upon paging the whole data is fetched thus resulting the reported behavior. So we suggest you define it as integer value. Please refer to the below API documentation link for more information  

https://help.syncfusion.com/js/api/ejgrid#members:pagesettings-pagesize 

Demo Sample Link: https://jsplayground.syncfusion.com/dmmd2x5q 

Regards, 

Ragavee U S. 

[Chris Mack]

Ah thank you, that did it.

Oddly, I took that code from a page that worked great.

[Ragavee U S]

Hi Chris, 

  

Thanks for your update. 

  

We are happy that your issue is resolved. 

  

Regards, 

Ragavee U S.