Guriddo » Topic: Load grid with addJSONData problem

Load grid with addJSONData problem

Guriddo
Load grid with addJSONData problem

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

Creator

Topic
February 2, 2010 at 9:49 pm #75378

mike.tihonchik
Participant

I am using dwr Ajax to return me a List> 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
Creator

Topic

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

Author

Replies
February 3, 2010 at 6:14 pm #92527

HoSpiTaL_gHoSt
Participant

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

February 3, 2010 at 10:48 pm #92539

mike.tihonchik
Participant

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…

February 4, 2010 at 12:03 pm #92541

HoSpiTaL_gHoSt
Participant

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 );

February 5, 2010 at 6:06 pm #92573

mike.tihonchik
Participant

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?

February 10, 2010 at 3:26 pm #92630

tony
Keymaster

Hello,

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

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

Regards

Tony

February 10, 2010 at 6:16 pm #92648

HoSpiTaL_gHoSt
Participant

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 }
Author

Replies