Hi Kannan,

Our developers have come back with a solution for this.  Someone pointed out that I wasn't setting the Type of the LoadOnDemand feature, which is not inferred when lazy loading.  He recommended to set the Type of the LoadOnDemand feature to Remote.

I have followed his suggestion and modified my sample.  I am attaching the sample to this post.  It demonstrates local sorting with the workaround provided earlier along with including lazy loading.

If you have any further questions or concerns with this, please let me know and I will be glad to help.

Hello Kannan,

I have attached a sample that demonstrates how to lazy load the grid.  I create the "Populate Grid" button and when this is called, the grid's datasource is set, which fetches the data from the server.  The issue I've encountered is that the entire datasource is retrieved at this point.

I have created a support case for you with an ID of CAS-140890-N9Y7T8.  The matter with the full datasource being retrieved has been determined to be a development issue and has been logged in our tracking system with ID: 176945.

I will leave this case open and update you with any new information.  You can view the status of the development issue connected to this case by going to the “Account” tab on our website, selecting "My Support Activity" and then this support case will be listed there.  Then, you may select the "Development Issues" tab to view details of this development issue.

Please let me know if you have any questions.

Hi Kannan,

The issue I am experiencing with lazy loading appears to be a bug.  I am bringing this up with our developers and will have another update with a development issue for you tomorrow.

Regarding the issue with the local sorting not updating after loading additional rows, our developers have suggested the following workaround.  An available workaround is to manually sort the column on rowsRequested event.  You can handle this with the following code:

 <script type="text/javascript">
     $(document).on("iggridloadondemandrowsrequested", "#grid1", function () {
         var $grid = $("#grid1"), grid = $grid.data("igGrid"), sorting = $grid.data("igGridSorting"), i, expr = $.extend([], grid.dataSource.settings.sorting.expressions);
         for (i = 0; i < expr.length; i++) {
             sorting.sortColumn(expr[i].fieldName, expr[i].dir);
         }
     });
 </script> 

I will have another update for you tomorrow.

Hello Kannan,

I have created logged issue with locally sorted columns not being sorted after more rows are loaded in our tracking system with ID: 176770.  The next step will be for a developer to review my investigation and confirm my findings or to offer a fix, or other resolution.

And regarding my sample that includes lazy loading, I have encountered an issue with loading my data and I am currently discussing this with my supervisor for further guidance.

I will have another update for you on Monday with more information.