Guriddo » Topic: How to read nested json list in jqgrid

How to read nested json list in jqgrid

Guriddo
How to read nested json list in jqgrid

This topic has 0 replies, 1 voice, and was last updated 12 years, 7 months ago by Damu.

Creator

Topic

December 25, 2013 at 5:46 am #81456

Damu

Participant

This is my Grid data

  $(document).ready(function (){<br />
var i; i=0;<br />
$.ajax({<br />
url: &#39;/display_rpt_expectedtableSchema?rpt_step_id=<%=@rpt_step_id%>&#038;header_data=true&#39;,<br />
success: function (data, st) {<br />
if (st == "success") {<br />
var columnData = jQuery.parseJSON(data)<br />
// for(i=0;i<columnData.source.length; i++)  {alert(&#39;how many loops&#39;); alert(i);<br />
jQuery("#schemalist").jqGrid({<br />
//url : &#39;/display_rpt_expectedtableSchema?rpt_step_id=<%=@rpt_step_id%>&#038;header_data=false&#39;,<br />
datastr: columnData.source,<br />
pager: &#39;#schemaPager&#39;,<br />
datatype: "jsonstring",<br />
colNames: [&#39;ExpTableName&#39;,&#39;ExpColumn&#39;, &#39;ExpType&#39;, &#39;ExpSize&#39;],<br />
cmTemplate: { title: false },<br />
//colModel:ColM,<br />
/*colModel:  [<br />
{name:&#39;tableName&#39;,index:&#39;tableName&#39;, width:145,jsonmap:&#39;columns&#39;+&#39;.&#39;+i+&#39;.&#39;+&#39;tableName&#39;},

$(document).ready(function (){

var i; i=0;

$.ajax({

url: '/display_rpt_expectedtableSchema?rpt_step_id=<%=@rpt_step_id%>&header_data=true',

success: function (data, st) {

if (st == "success") {

var columnData = jQuery.parseJSON(data)

// for(i=0;i<columnData.source.length; i++) {alert('how many loops'); alert(i);

jQuery("#schemalist").jqGrid({

//url : '/display_rpt_expectedtableSchema?rpt_step_id=<%=@rpt_step_id%>&header_data=false',

datastr: columnData.source,

pager: '#schemaPager',

datatype: "jsonstring",

colNames: ['ExpTableName','ExpColumn', 'ExpType', 'ExpSize'],

cmTemplate: { title: false },

//colModel:ColM,

/*colModel: [

{name:'tableName',index:'tableName', width:145,jsonmap:'columns'+'.'+i+'.'+'tableName'},

                        {name:&#39;name&#39;,index:&#39;name&#39;, width:145,jsonmap:&#39;columns&#39;+&#39;.&#39;+i+&#39;.&#39;+&#39;name&#39;},<br />
{name:&#39;type&#39;,index:&#39;type&#39;, width:145,jsonmap:&#39;columns&#39;+&#39;.&#39;+i+&#39;.&#39;+&#39;type&#39;},<br />
{name:&#39;size&#39;,index:&#39;size&#39;, width:145,jsonmap:&#39;columns&#39;+&#39;.&#39;+i+&#39;.&#39;+&#39;size&#39;}<br />
],*/<br />
colModel:  [<br />
{name:&#39;tableName&#39;,index:&#39;tableName&#39;, width:145,jsonmap:&#39;tableName&#39;},<br />
{name:&#39;name&#39;,index:&#39;name&#39;, width:145,jsonmap:&#39;name&#39;},<br />
{name:&#39;type&#39;,index:&#39;type&#39;, width:145,jsonmap:&#39;type&#39;},<br />
{name:&#39;size&#39;,index:&#39;size&#39;, width:145,jsonmap:&#39;size&#39;}<br />
],<br />
<br />
//jsonReader:{repeatitems: false,root:&#39;source&#39;+&#39;.&#39;+i+&#39;.&#39;+&#39;columns&#39;},<br />
jsonReader:{repeatitems: false,root:&#39;source.0.columns&#39;},<br />
rowNum: 25,<br />
viewrecords: true,<br />
caption: "Expected Schema",<br />
height: 600,<br />
width: 600,<br />
//multiselect: true,<br />
autoFitColumns: true,<br />
loadonce: true,<br />
autoencode: true,<br />
shrinkToFit: false,<br />
ignoreCase: true<br />
});<br />
<br />
$("#schemalist").jqGrid(&#39;navGrid&#39;,&#39;#schemaPager&#39;,{edit:false,add:false,del:false});<br />
<br />
}<br />
<br />
//      }<br />
},<br />
error: function () {<br />
alert("Error with AJAX callback");<br />
}<br />
});<br />
<br />
});

{name:'name',index:'name', width:145,jsonmap:'columns'+'.'+i+'.'+'name'},

{name:'type',index:'type', width:145,jsonmap:'columns'+'.'+i+'.'+'type'},

{name:'size',index:'size', width:145,jsonmap:'columns'+'.'+i+'.'+'size'}

],*/

colModel: [

{name:'tableName',index:'tableName', width:145,jsonmap:'tableName'},

{name:'name',index:'name', width:145,jsonmap:'name'},

{name:'type',index:'type', width:145,jsonmap:'type'},

{name:'size',index:'size', width:145,jsonmap:'size'}

],

//jsonReader:{repeatitems: false,root:'source'+'.'+i+'.'+'columns'},

jsonReader:{repeatitems: false,root:'source.0.columns'},

rowNum: 25,

viewrecords: true,

caption: "Expected Schema",

height: 600,

width: 600,

//multiselect: true,

autoFitColumns: true,

loadonce: true,

autoencode: true,

shrinkToFit: false,

ignoreCase: true

});

$("#schemalist").jqGrid('navGrid','#schemaPager',{edit:false,add:false,del:false});

}

// }

},

error: function () {

alert("Error with AJAX callback");

}

});

});

<p><strong>and Here is my JSON Object</strong></p><br />
<p>{"source":[{"id":1,"columns":[{"name":"Jdate","type":"Date","size":"0","tableName":"c1"},</p><br />
<p>{"name":"CustId","type":"Int","size":"0","tableName":"c2"},</p><br />
<p>{"name":"Jdate","type":"Date","size":"0","tableName":"c3"},</p><br />
<p>{"name":"Jdate","type":"Date","size":"0","tableName":"c4"},</p><br />
<p>{"name":"Jdate","type":"Date","size":"0","tableName":"c5"}]},</p><br />
<p>{"id":2,"columns":[{"name":"Amt","type":"Money","size":" 0","tableName":"Loan"},</p><br />
<p>{"name":"Tenure","type":"int","size":" 0","tableName":"Loan"}]},</p><br />
<p>{"id":3,"columns":[{"name":"Amt","type":"Money","size":" 0","tableName":"xyz"},</p><br />
<p>{"name":"Tenure","type":"int","size":" 0","tableName":"xyz"}]}]}</p>

and Here is my JSON Object

{"source":[{"id":1,"columns":[{"name":"Jdate","type":"Date","size":"0","tableName":"c1"},

{"name":"CustId","type":"Int","size":"0","tableName":"c2"},

{"name":"Jdate","type":"Date","size":"0","tableName":"c3"},

{"name":"Jdate","type":"Date","size":"0","tableName":"c4"},

{"name":"Jdate","type":"Date","size":"0","tableName":"c5"}]},

{"id":2,"columns":[{"name":"Amt","type":"Money","size":" 0","tableName":"Loan"},

{"name":"Tenure","type":"int","size":" 0","tableName":"Loan"}]},

{"id":3,"columns":[{"name":"Amt","type":"Money","size":" 0","tableName":"xyz"},

{"name":"Tenure","type":"int","size":" 0","tableName":"xyz"}]}]}

Creator

Topic

You must be logged in to reply to this topic.

Stay connected with us in your favorite flavor!

How to read nested json list in jqgrid

Search Forum

Recent Replies

Forum Statistics

UserOnline