jQuery Grid Plugin - jqGrid - Topic: Load grid with addJSONData problem

HoSpiTaL_gHoSt on Load grid with addJSONData problem

Wed, 10 Feb 2010 18:16:01 +0200

Yes, I'm sorry for the confusion, the array I showed you also used a jsonReader. If you don't want/need to use a jsonReader, your array should look like this:

{
"rows":[{'company':'1','TG_NAME':'1','activeGroup':'1'},{'company':'2','TG_NAME':'2','activeGroup':'2'}],
"records":2,
"total":1,
"page":1
}

tony on Load grid with addJSONData problem

Wed, 10 Feb 2010 15:26:04 +0200

Hello,

You should configure your jsonReader. Please read here how this can be achieved

http://www.trirand.com/jqgridw.....#json_data

Regards

Tony

mike.tihonchik on Load grid with addJSONData problem

Fri, 05 Feb 2010 18:06:25 +0200

Thank you for that information… However, i am still facing the problem. This is my code:

jQuery('#terminalGroups').jqGrid({

datatype: 'json',

colNames: ['Company','Name','Active'],

colModel: [

{name:'company', index:'company', width:500},

{name:'TG_NAME', index:'TG_NAME', width:300},

{name:'activeGroup', index:'activeGroup', width:195} ],

pager: jQuery('#terminalGroupPager'),

rowNum: 10,

rowList: [10,20,30],

sortorder: 'desc',

viewrecords: true,

imgpath: 'jquery/jqueryUI/css/sunny/images',

caption: 'Merchant Groups',

height: '490px'

});

var something = { "data":[{'company':'1','TG_NAME':'1','activeGroup':'1'},{'company':'2','TG_NAME':'2','activeGroup':'2'}], "totalRows":2, "totalPages":1, "page":1 };

jQuery('#terminalGroups')[0].addJSONData( something );

However, I get JS syntax error, and when I debug, it points to this code:

($.jgrid.useJSON===true&&typeof(JSON)==="object"&&typeof(JSON.parse)==="function")

any idea what might that be?

HoSpiTaL_gHoSt on Load grid with addJSONData problem

Thu, 04 Feb 2010 12:03:38 +0200

This is what your array should look like:

{
"data":[{'company':'1','TG_NAME':'1','activeGroup':'1'},{'company':'2','TG_NAME':'2','activeGroup':'2'}],
"totalRows":2,
"totalPages":1,
"page":1
}

And you should call addJSONData like this:

jQuery('#terminalGroups')[0].addJSONData( result );

mike.tihonchik on Load grid with addJSONData problem

Wed, 03 Feb 2010 22:48:10 +0200

Thank you for reply, but I have read that already... The problem is it does not specify much about data array (what should it look like). Here is example data what I use:

var exmpl = "[{'company':'1','TG_NAME':'1','activeGroup':'1'},{'company':'2','TG_NAME':'2','activeGroup':'2'}]";

This looks like a proper JS array to me...

HoSpiTaL_gHoSt on Load grid with addJSONData problem

Wed, 03 Feb 2010 18:14:13 +0200

Hi. Read the jqGrid documentation, everything is explained there! addJSONData is a special method:

Populates a grid with the passed data (an array).This method should be used this way - Example: Suppose we have data from a particular webservice (jsonresponse), then
var mygrid = jQuery(”#”+grid_id)[0];
var myjsongrid = eval(”(”+jsonresponse.responseText+”)”);
mygrid.addJSONData(myjsongrid);
myjsongrid = null;
jsonresponse =null;
will populate the data to the grid. And, of course, the data in myjsongrid can be manipulated before being passed to addJSONData.

See http://www.trirand.com/jqgridwiki/doku.php?id=wiki:methods

mike.tihonchik on Load grid with addJSONData problem

Tue, 02 Feb 2010 21:49:44 +0200

I am using dwr Ajax to return me a List<Map<String, String>> and I am trying to load the grid.

This is how I define my grid:

jQuery('#terminalGroups').jqGrid({

datatype: 'clientSide',

colNames: ['Company','Name','Active'],

colModel: [

{name:'company', index:'company', width:500},

{name:'TG_NAME', index:'TG_NAME', width:300},

{name:'activeGroup', index:'activeGroup', width:195} ],

pager: jQuery('#terminalGroupPager'),

rowNum: 10,

rowList: [10,20,30],

sortorder: 'desc',

viewrecords: true,

imgpath: 'jquery/jqueryUI/css/sunny/images',

caption: 'Merchant Groups',

height: '490px'

});

Now, I get a structure back from Ajax call, and I want to add it using following command:

jQuery('#terminalGroups').addJSONData( result );

however, I get the JS error that "object does not support this property or method". However, if I iterate through "result" and use

jQuery('#terminalGroups').addRowData( <%=index%>, result[<%=index%>] );

it works just fine...

What am I doing wrong on addJSONData???