Hello Mike,

Instead that I point you to the right direction, it seems that you do not have read the docs to the end.

You should read the other chapter from the docs – JSON dot notation.

http://www.trirand.com/jqgridwiki/doku.php?id=wiki:retrieving_data#json_dot_notation

So in order to work this yo should first configurire the jsonReader

jsonReader : {

root : “states.state”,

repeatitems: false

}

and then in your colModel to you the property jsonmap. I will do for the first field, you will finish the other.

colModel:[
{name:'name',index:'name', width:75, jsonmap:”@attributes.name”}

…

// do it for others

},

]

Hope this help.

Best Regards

Tony

Hello,

Just tested your configuration with the data provided from the link.

It works perfectly except that:

1. You have errror into the code:

…jqGrid({
..
jsonReader: {
root: “states.state”,
repeatitems: false
}, <==========Error
});

2. You should provide a info for the page, but instead it work without this setting.
If you need online example with your settings I'm ready to prepare for you.

Kind Regards
Tony

Hello,

Here is your config with the response:

http://trirand.com/blog/jqgrid/demo3.html

Regards

Tony

I am also unable to get column sorting to work. Any suggestions?