assign data from multilevel object to jqgrid
<p>r I gave root:"userProfileInformation" and it worked fine for  4 column of colModel, I am facing a problem in mapping json to jqgrid</p>

<pre><code>My json data is 
"
{"page":"1","total":"2","records":"10","userProfileInformation":[{"userId":24387
3,"userName":"admin","loginId":"admin","firstName":"Tom","lastName":"Adm
in","displayName":"Admin, tom ","role":"Administrative 
Coordinator","roleId":"1016","email":"dummy@dummy.com","timeZone":"America/Los_A
ngeles","timeZoneDesc":"America/Los_Angeles","organizationNodes":[{"orgNodeId":1
08784,"customerId":32462,"orgNodeCategoryId":39074,"orgNodeName":"Weblogic 
Scoring","createdBy":23722,"createdDateTime":"Dec 9, 2009 3:34:57 
AM","updatedBy":23722,"updatedDateTime":"May 15, 2011 11:05:49 
PM","activationStatus":"AC"}],"userContact":{"addressId":0,"addressLine1":"","ad
dressLine2":"","city":"","state":"","stateDesc":"","zipCode":"","zipCode1":"","z
ipCode2":"","primaryPhone":"","primaryPhone1":"","primaryPhone2":"","primaryPhon
e3":"","primaryPhone4":"","secondaryPhone":"","secondaryPhone1":"","secondaryPho
ne2":"","secondaryPhone3":"","secondaryPhone4":"","faxNumber":"","faxNumber1":""
,"faxNumber2":"","faxNumber3":""},"userPassword":{"oldPassword":"","newPassword"
:"","confirmPassword":"","hintQuestion":"","hintQuestionId":"1000","hintAnswer":
"dog"},"actionPermission":"TTTT"}]}"





JQGrid code :

    $("#list2").jqGrid({
     datatype: function(pdata) {
     getData(pdata);
    },
     colNames:['User Name','Login Id', 'Email','Organization', 'Role'],
    colModel:[
     {name:'userName',index:'userName', width:150, editable: true},
     {name:'loginId',index:'loginId', width:150, editable: true},
     {name:'email',index:'email',editable: true, width:150},
     {name:'orgNodeName',index:'orgNodeName',editable: true, width:150,edittype:"newtree",editoptions:{readonly:true}},
     {name:'role',index:'role',editable: true, width:150, align:"right"}
     ],
    jsonReader: { repeatitems : false, root:"userProfileInformation", id:"userId",records: function(obj) { return obj.userProfileInformation.length; } },
     rowNum:10,
     loadonce:true,
     multiselect:false,
     rowList:[10,20,30],
     pager: '#pager2',
     sortname: 'empId',
     viewrecords: true,
     sortorder: "desc",
     editurl: 'userOrgNodeHierarchyGrid.do',
     caption:"Search Result" }); 

In jsonReader I gave root:"userProfileInformation" and it worked fine for  4 column of colModel, except "orgNodeName" , which inside 'organizationNodes' object and this is sub object of userProfileInformation.
So how to retrieve orgNodename.

I even tried {name:'organizationNodes.orgNodeName',index:'organizationNodes.orgNodeName',editable: true, width:150,edittype:"newtree",editoptions:{readonly:true}},


Kindly reply ASAP.
</code></pre>
