jQuery Grid Plugin - jqGridForum

Topic RSS

retreivel jqGrid data with json callback

30/06/2009
02:54

mbanaouas

Member

Members

Forum Posts: 6

Member Since:
30/06/2009

Offline

retreivel jqGrid data with json callback

Hi,

jQuery JavaScript Library v1.3.2, jqGrid 3.4.2 - jQuery Grid

I'm trying to retreive jqGrid data with a json callback. But the grid is showing 'Loading...' and firebug detect this error:

n is undefined

jqGrid()()grid.base-min.js (ligne 9)

complete()jquery.js (ligne 3655)

onreadystatechange()()jquery.js (ligne 3607)

[Image Can Not Be Found];(function(b)...

the data retreived is :

{
total: "1",
page: "1",
records: "3",
rows :
[
{id:"1",invdate:"2007-10-01",name:"test",note:"note",amount:"200.00",tax:"10.00",total:"210.00"},
{id:"2",invdate:"2007-10-02",name:"test2",note:"note2",amount:"300.00",tax:"20.00",total:"320.00"},
{id:"3",invdate:"2007-09-01",name:"test3",note:"note3",amount:"400.00",tax:"30.00",total:"430.00"}
]
}
thanks for any help

30/06/2009
19:05

mbanaouas

Member

Members

Forum Posts: 6

Member Since:
30/06/2009

Offline

the problem is caused by bad data format.

for jqGrid, json data must to be in a special format :

{
"page":"1",
"total":1,
"records":"3",
"rows":[
    {"id":"1","cell":["1","2009-06-15","CLI-1","75000","5000","80000","cli-1"]},
    {"id":"2","cell":["2","2009-06-08","CLI-2","45000","5000","50000","cli-2"]},
    {"id":"3","cell":["3","2009-06-01","CLI-3","25000","5000","30000","cli-3"]}
]
}

Now it works fine !

All RSS

Forum Timezone: Europe/Sofia

Most Users Ever Online: 715

Currently Online:
60 Guest(s)

Currently Browsing this Page:
1 Guest(s)