Datagrid totals seem inconsistent with records displayed

[peter900]

The screen shot below shows a datagrid with records 41 - 82 displayed ( with vertical scrolling ) yet the paging control at the bottom says Displaying 41 to 60 of 193 items   The 193 total is correct but why is the record range incorrect ?  Thanks.

https://www.dropbox.com/s/qns5zokjp3rji2t/eui09092016a.png?dl=0

[jarry]

Please look at this example http://code.reloado.com/alecay/edit#preview. It works fine.

[peter900]

Thanks Jarry.  Sorry but I wasn't suggesting a code problem - like your example I have grids that display the correct totals.  Perhaps you or someone could look at the json which is driving the grid with the problems. It validates fine and I cannot see any issues.

https://www.dropbox.com/s/sweb527qme3xt4i/euiforumjson1.txt?dl=0

Thanks.

[iklotzko]

Peter,

I noticed in your data the "Id" field is null in many--if not all--cases: this should be populated. Also, make sure you specify a value for the "idField", in your case it would read " idField: 'Id', ... "


If that doesn't solve your problems, can you please post relevant code AND post the request header you use to get the data shown.

[peter900]

Thanks iklotzko - I'll look at filling the id field and then providing the identifier of the unique field in the JSON - like....

{"total":193,"idField: 'Id',"rows":[{"Id":"e778322rgy7","CreatedDate":"2016-08-28T14:43:45.000Z","Leader__c":".....

Thanks for your help on this.

[iklotzko]

Peter,

No problem! But, it's not in the returned results you want to specify the property: idField: 'Id'

You'll want this in the grid options itself, either through data-options property of your target element

Code:

<table class="easyui-datagrid" data-options="... idField: 'id', url: 'myurl.php'... " ..</table>

or if you use JavaScript to initialize your datagrid

Code:

$('#mygrid').datagrid({
   .
    idField: 'Id',
    url: 'myurl.php',
   .
   .
});

Please tell me if it works for you!
Ira

[jarry]

This example works fine.
http://code.reloado.com/alecay/2/edit#preview

[iklotzko]

Oh... Peter, are you actually using client side data or fetching from a URL?

I just tried this out in fiddle and the issue here is that it is a bit more complex for client pagination. You should check the examples out in the demo section of easyui.

Server-side pagination is considerably easier and consists mainly of determining which rows to bring back. Look at the examples.