Guriddo » Topic: Json problem

Json problem

Guriddo
Json problem

This topic has 5 replies, 2 voices, and was last updated 16 years, 5 months ago by tony.

Creator

Topic

December 16, 2009 at 7:20 am #74970

digitBoy

Participant

Hi, firstly congratulation for the plugin and the community.

I am using Codeigniter 1.7.2 and jqGrid, but I have a problem. I also say that after reading the wiki again and again I have not been able to find a solution for my json data. The respond that I get is OK, using Firebug is the following:

POST:

_search	`false`
nd	`1260940642625`
page	`1`
rows	`20`
sidx	`idpieza`
sord	`desc`

RESPOND:

[{"idpieza":"1","descripcion":"Primera pieza de mi vida",<br />"fechaAlta":"2008-12-31 23:59:59","fechaMod"</code><code>:"2009-01-31 23:59:59",<br />"vista":"1","vertical":"0","width":"500","height":"400","top":"10",<br />"left":"20"</code><code>,"color":"blue","background":"#efefef","border":"4px solid #A9A9A9",<br />"bloque_background":"#fff","usuario"</code><code>:"0"},{"idpieza":"2","descripcion":"Segundona",<br />"fechaAlta":"2009-02-27 23:59:59","fechaMod":"2009-11-06</code><code> 23:59:59","vista":"1",<br />"vertical":"1","width":"600","height":"600","top":"500","left":"300","color":"red"</code><code>,<br />"background":"white","border":"1px solid green","bloque_background":"white","usuario":"0"},........<br /><br />CODE:<br /><br />     jQuery("#lista").jqGrid({<br />            ajaxGridOptions : {type:"POST"},<br />            serializeGridData : function(postdata) {<br />                postdata.page = 1;<br />                return postdata;<br />            },<br />            url:&#39;piezas/cristina&#39;,<br />            datatype: "json",<br />            colNames:[&#39;ID&#39;,&#39;Descripcion&#39;, &#39;fechaAlta&#39;, &#39;fechaMod&#39;,&#39;vista&#39;,&#39;Vertical&#39;,&#39;width&#39;,<br />                &#39;height&#39;,&#39;top&#39;,&#39;left&#39;,&#39;color&#39;,&#39;background&#39;,&#39;border&#39;,&#39;bloque_background&#39;],<br />            colModel:[<br />                {name:&#39;idpieza&#39;,index:&#39;idpieza&#39;, width:55},<br />                {name:&#39;descripcion&#39;,index:&#39;descripcion&#39;, width:90},<br />                {name:&#39;fechaAlta&#39;,index:&#39;fechaAlta&#39;, width:100},<br />                {name:&#39;fechaMod&#39;,index:&#39;fechaMod&#39;, width:80, align:"right"},<br />                {name:&#39;vista&#39;,index:&#39;vista&#39;, width:80, align:"right"},<br />                {name:&#39;vertical&#39;,index:&#39;vertical&#39;, width:80,align:"right"},<br />                {name:&#39;width&#39;,index:&#39;width&#39;, width:150, sortable:false},<br />                {name:&#39;height&#39;,index:&#39;height&#39;, width:150, sortable:false},<br />                {name:&#39;top&#39;,index:&#39;top&#39;, width:150, sortable:false},<br />                {name:&#39;left&#39;,index:&#39;left&#39;, width:150, sortable:false},<br />                {name:&#39;color&#39;,index:&#39;color&#39;, width:150, sortable:false},<br />                {name:&#39;background&#39;,index:&#39;background&#39;, width:150, sortable:false},<br />                {name:&#39;border&#39;,index:&#39;border&#39;, width:150, sortable:false},<br />                {name:&#39;bloque_background&#39;,index:&#39;bloque_background&#39;, width:150, sortable:false}<br />            ],<br />            rowNum:20,<br />            width:900,<br />            rowList:[10,20,30],<br />            pager: &#39;#paginacion&#39;,<br />            sortname: &#39;idpieza&#39;,<br />            viewrecords: true,<br />            sortorder: "desc",<br />            caption:"Piezas registradas en el sistema por el usuario"<br />        });<br />        jQuery("#pjqgajax").jqGrid(&#39;navGrid&#39;,&#39;#pjqgajax&#39;,{edit:false,add:false,del:false});<br /><br /><br /><br />

[{"idpieza":"1","descripcion":"Primera pieza de mi vida", "fechaAlta":"2008-12-31 23:59:59","fechaMod"</code><code>:"2009-01-31 23:59:59", "vista":"1","vertical":"0","width":"500","height":"400","top":"10", "left":"20"</code><code>,"color":"blue","background":"#efefef","border":"4px solid #A9A9A9", "bloque_background":"#fff","usuario"</code><code>:"0"},{"idpieza":"2","descripcion":"Segundona", "fechaAlta":"2009-02-27 23:59:59","fechaMod":"2009-11-06</code><code> 23:59:59","vista":"1", "vertical":"1","width":"600","height":"600","top":"500","left":"300","color":"red"</code><code>, "background":"white","border":"1px solid green","bloque_background":"white","usuario":"0"},........ CODE: jQuery("#lista").jqGrid({ ajaxGridOptions : {type:"POST"}, serializeGridData : function(postdata) { postdata.page = 1; return postdata; }, url:'piezas/cristina', datatype: "json", colNames:['ID','Descripcion', 'fechaAlta', 'fechaMod','vista','Vertical','width', 'height','top','left','color','background','border','bloque_background'], colModel:[ {name:'idpieza',index:'idpieza', width:55}, {name:'descripcion',index:'descripcion', width:90}, {name:'fechaAlta',index:'fechaAlta', width:100}, {name:'fechaMod',index:'fechaMod', width:80, align:"right"}, {name:'vista',index:'vista', width:80, align:"right"}, {name:'vertical',index:'vertical', width:80,align:"right"}, {name:'width',index:'width', width:150, sortable:false}, {name:'height',index:'height', width:150, sortable:false}, {name:'top',index:'top', width:150, sortable:false}, {name:'left',index:'left', width:150, sortable:false}, {name:'color',index:'color', width:150, sortable:false}, {name:'background',index:'background', width:150, sortable:false}, {name:'border',index:'border', width:150, sortable:false}, {name:'bloque_background',index:'bloque_background', width:150, sortable:false} ], rowNum:20, width:900, rowList:[10,20,30], pager: '#paginacion', sortname: 'idpieza', viewrecords: true, sortorder: "desc", caption:"Piezas registradas en el sistema por el usuario" }); jQuery("#pjqgajax").jqGrid('navGrid','#pjqgajax',{edit:false,add:false,del:false});

>I know that maybe this json is not available for jqGrid, but i am trying all possibilities. I tried different versions of the jsonReader but not successfully.

So if something is wrong, can anybody help me?

Thanks indeed.

Creator

Topic

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

Author

Replies

December 17, 2009 at 7:42 pm #91515

tony

Keymaster

Hello,

In this case you should configure the jsonReader – and set the option repeatitems to false.

More you can find here:

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

Regards

Tony

December 18, 2009 at 5:04 am #91524

digitBoy

Participant

Thanks for answering.

I tried, but do you think it is possible to make a jsonReader for a json like:

[{"id":"1","attr1":"x",</code><code>"attr2":"y",</code><code>"attr3":"z"},</code><br /><code>{"id":"2","attr1":"m",</code><code>"attr2":"n",</code><code>"attr3":"o"}</code>,<br /><code>{"id":"3","attr1":"j",</code><code>"attr2":"k",</code><code>"attr3":"l"}</code>]<br /><br />Because in that way is my json and i couldn

[{"id":"1","attr1":"x",</code><code>"attr2":"y",</code><code>"attr3":"z"},</code> <code>{"id":"2","attr1":"m",</code><code>"attr2":"n",</code><code>"attr3":"o"}</code>, <code>{"id":"3","attr1":"j",</code><code>"attr2":"k",</code><code>"attr3":"l"}</code>] Because in that way is my json and i couldn

December 18, 2009 at 9:31 pm #91545

tony

Keymaster

Hello,

Yes it is possible to do this. Do not forget to put the totalpages and other needed attributes for the response.

Best Reagrds

Tony

December 18, 2009 at 11:28 pm #91557

digitBoy

Participant

I am sorry i am triying and i am not getting any good result . Could you help me ? Because for example, the att “recordstotal” is number of records for the query, but mine is dynamic (some json would be of 30 items, another of 2). I am sorry but i am really lost.

Thanks.

December 22, 2009 at 9:32 am #91589

Json problem

Search Forum

Recent Replies

Forum Statistics

UserOnline