Guriddo » Topic: Local Data Paging & Sorting

Local Data Paging & Sorting

Guriddo
Local Data Paging & Sorting

This topic has 5 replies, 2 voices, and was last updated 15 years, 4 months ago by feto.

Creator

Topic
December 15, 2010 at 7:48 pm #77756

feto
Participant

Hello,

So upgrading from 3.6 to 3.8 has caused several breaks. And I've been pounding my head for 2 days trying to fix them.

1. addJSONData stopped displaying data in the grid, this was do to the stricter rules on json formatting – Finally FIXED

2. Now data is displaying in grid but when i go to change the page or sort on column the data disappears from the grid.

I first define the grid this way:
Creator

Topic

Viewing 5 replies - 1 through 5 (of 5 total)

Author

Replies
December 15, 2010 at 10:08 pm #96911

OlegK
Participant

First of all you should not use parameters rowNum: 0 and rowTotal: -1. It is better to set rowNum to one from the values from the rowList array.

Instead of usage of separate $.ajax call it is better to use

ajaxGridOptions: { contentType: 'application/json; charset=utf-8' } url: dataUrl, mtype: 'POST', datatype: 'json'

If the returned data contain array of objects having properties Id and Name, then you should additionally include parameter

jsonReader: { repeatitems: false }

See this, this and this answer for more informations and examples.

Best regards
Oleg

December 15, 2010 at 11:28 pm #96912

feto
Participant

Correct on the RowNum: 0 and rowTotal: -1, rowNum was supposed to be 10 but i copied it wrong.

But the reason i didnt call back to the server from the grid definition itself is because, and i should have mentioned it before i am actually returning 4 grid result sets from the server in one call and i populate 4 different datatype local grids locally from one server call so my AJAX post really looks like this:

December 15, 2010 at 11:41 pm #96913

feto
Participant

And I guess the question really is why after the grid is displaying my data and the grid is datatype:local, why doesn't local paging and sorting just work? Why would attempting to page or sort make the data disappear from the grid?

December 16, 2010 at 12:38 am #96914

feto
Participant

Even when I write a hardcoded example it does the same thing, data adds and displays fine but when I try and sort on the Name column (All Row Data disappears):

December 16, 2010 at 1:21 am #96915

feto
Participant

Sorry for all the post :))) but am working through this now so my progress is currently fluid New discovery (reference example in my post above): grid.addJSONData(rr); //Adds data but local sort and paging NOT WORK $(“#Grid”).jqGrid(“addRowData”, “Id”, rr.rows); //adds data and local sort and paging WORKS! Why?? And i guess i can use addRowData instead of addJSONData as long as performance is similar on large data sets?
Author

Replies