Guriddo » Topic: handle json data with root element

handle json data with root element

Guriddo
handle json data with root element

This topic has 6 replies, 4 voices, and was last updated 16 years, 4 months ago by tony.

Creator

Topic
December 10, 2009 at 4:35 pm #74927

gsproof
Participant

Hi,

I have a server that returns JSON data for jqgrid in the format with root element, like:

{”data”:{”currPage”:1,”totalPages”:1,”totalRecords”:2,”users”:[{“id”:1, name”:”x1″, email:”e1″},{“id”:2,email:”e2″}]}}

I was trying to use the dot notation for root, page, etc, but with no luck.

jsonReader: {
Creator

Topic

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

Author

Replies
December 11, 2009 at 2:29 pm #91375

tony
Keymaster

Hello

if your output is like this

{”d”:{”currPage”:1,”totalPages”:1,”totalRecords”:2,”users”:[{“id”:1, name”:”x1″, email:”e1″},{“id”:2,email:”e2″}]}}

you should not do anything.

I.e not data, but d. jqGrid support the d property generated from some Microsoft products.

Another possible solution is to use a datatype as function , where you can put what you want to the json parser.

See demos.

Best regards

Tony

December 12, 2009 at 9:10 am #91386

admin
Keymaster

Hello,

I have a similar problem to the above however, the instead of “d”, the name coming back from my web service is “ListData”. Also, this will change depending on the type of the request. I cannot change the returned string from the web service so I need to handle this somehow on the javascript side.

{“ListData” : {“Success”:”true”,”Record”:”1″, “rows”:[{“MyID” : “7”,”MyTitle” : “MyTitle”,”StartDate” : “09.12.2009”,”EndDate” : “31.12.2009”}]}}

How do I specify the jsonReader so the grid can read the data contained in the rows array? I tried the following with no success:

rows: 'ListData'
rows: 'ListData.rows'

If I populate the grid using addRowData, it works fine but I want to have it autopopulated using the json datatype. I know I am missing something very basic.

Can anyone help me?

Thanks,
Rushi

December 13, 2009 at 6:03 pm #91406

tony
Keymaster

Hello,

I suggest you in this case to use datatype as function. The code can look like this

jQuery(“#listdt”).jqGrid({

December 15, 2009 at 2:00 am #91436

Rushi
Participant

Thanks a lot, Tony. I'll try it out right away. Another question though, will this approach work in case of the “Search Big Sets” example that you have in the demo? I need to display list of records from a database table in the grid but the database table contains over 80,000 records. I was wondering if this approach with the custom datatype function combined with the “Search Big Sets” logic work for such a kind of load. Appreciate your response.

Thanks,

Rushi

December 15, 2009 at 2:32 am #91437

Rushi
Participant

Tony,

Another thing: I used the above approach and it seems work fine (although I am waiting to get an answer from you for the “Search Big Sets”). The problem I am facing is I have a loadComplete function tied to the grid and if I use your above suggested approach, my loadComplete function doesn't get called. Am I missing something?

December 15, 2009 at 7:23 pm #91467

tony
Keymaster

Hello,

As you can see – in case of custom datatype you should add your code from loadComplete after addJSONData, or use gridComplete event which is lunched when all data is in the grid.

Regards

Tony
Author

Replies