Forum
November 2nd, 2014
A
A
A
Topic RSS
Related Topics
Offline
The forums are currently locked and only available for read only access



JQGrid cannot load JSON data from struts 2 action
26/06/2012
18:43
18:43

zigzak
New Member
Members
Forum Posts: 2
Member Since:
26/06/2012
26/06/2012

Hi everyone,
I have a problem when loading data to jqgrid from struts 2 action
My action return JSON data:
{"page":"1","records":"31",
"rows":["{'id':'1','cell':['1','Cant open destop','Destop','Easy','duongls','huyld','minhnq','Finance ','Open']}",
"{'id':'2','cell':['2','Cant log to email','Email','Normal','thangtd','minhnq','longnh','Secretary ','Assigned']}",
"{'id':'3','cell':['3','No internet access Edited ver 2 longnh','Connection','Hard','thangtd','longnh','longnh','Secretary ','Closed']}",
"{'id':'4','cell':['4','Request password','Account','Normal','dungtq','honglm','longnh','Director','Cancelled']}",
"{'id':'5','cell':['5','Cant open latop','Laptop','Hard','duongls','huyld','minhnq','Director','Closed']}",
"{'id':'6','cell':['6','issue 11111111111111','','','dungtq','longnh','','Planning','Open']}",
"{'id':'7','cell':['7','Issue ku minh heo','','','dungtq','longnh','','Planning','Open']}",
"{'id':'8','cell':['8','New ticket 12345','','','dungtq','longnh','','Planning','Open']}",
"{'id':'9','cell':['9','Mail server cannot connect','','','haitct','longnh','','Director','Open']}",
"{'id':'10','cell':['10','aaaaaaaaaaaa','','','dungtq','longnh','','Planning','Open']}"],"total":"4"}
JSP:
$("#list1").jqGrid({
url: "<%=request.getContextPath()%>/pagingIssue?time="+new Date().getTime(),
colNames:['Id','Name', 'Type','Severity', 'Owner','Register', 'Responsor', 'Department','Status'],
colModel:[
{name:'issId',index:'issId', width:40, sortable:true},
{name:'issName',index:'issName', width:200, sortable:true},
{name:'issType',index:'issType', width:100, sortable:true},
{name:'issSeverity',index:'issSeverity', width:100, sortable:true},
{name:'issOwner',index:'issOwner', width:80, sortable:true},
{name:'issRegister',index:'issRegister', width:100, sortable:true},
{name:'issResponsor',index:'issResponsor', width:100, sortable:true},
{name:'department',index:'department', width:120, sortable:true},
{name:'issStatus',index:'issStatus', width:80, sortable:true}],
rowNum:10,
rowList:[10,15,20],
pager: '#pager1',
sortname: 'issId',
datatype: 'json',
recordpos: 'left',
viewrecords: true,
sortorder: 'desc',
multiselect: true,
caption: 'Issue List' });
});
The table just show Loading.... forever
Can anyone help me
I guess the problem is your jqGrid instance does not know where it can find the records in your result.
$("#list1").jqGrid({
url: "<%=request.getContextPath()%>/pagingIssue?time="+new Date().getTime(),
jsonReader: { root: "rows" },
// more config
});
My Blog: http://www.jgeppert.com @Twitter: http://twitter.com/jogep
Forum Timezone: Europe/Sofia
Most Users Ever Online: 715
Currently Online:
44 Guest(s)
Top Posters:
OlegK: 1255
markw65: 179
kobruleht: 144
phicarre: 132
YamilBracho: 124
Renso: 118
Member Stats:
Guest Posters: 447
Members: 11373
Moderators: 2
Admins: 1
Forum Stats:
Groups: 1
Forums: 8
Topics: 10592
Posts: 31289
Newest Members:
, razia, Prankie, psky, praveen neelam, greg.valainis@pa-tech.comModerators: tony: 7721, Rumen[Trirand]: 81
Administrators: admin: 66