Forum
November 2nd, 2014
A
A
A
The forums are currently locked and only available for read only access
Topic RSS
Related Topics
jsonstring problem with pagination v3.8
02/02/2011
15:58
15:58
Wakamolee
Member
Members
Forum Posts: 5
Member Since:
02/02/2011
02/02/2011
Offline
I upgraded from v3.6.2 to v3.8.2, and the pagination shows incorrect values when the data is loaded using datatype:"jsonstring".
I have 447 records, but when using jsonstring the pagination only shows "1-10 of 10 rows". When using datatype:"json" everything works fine.
Here is my grid definition (short test version):
$("#actividades_test").jqGrid({
datatype: 'jsonstring',
datastr : json_acts,
colNames:['Codigo','Descripcion', 'Unidad', 'P. unit.', ' ', 'Grupo'],
colModel :[
{name:'id', index:'actividad:id', width:60, hidden:true},
{name:'descripcion', index:'actividad:descripcion', width:310,editable:true,editrules:{required:true}},
{name:'unidad', index:'actividad.unidad', align:'center', width:60, search:false},
{name:'total', index:'total', width:60, align:'right', search:false, sortable:false,formatter:'number'},
{name:'add', index:'add', width:20, align:'right', search:false, sortable:false,fixed:true},
{name:'grupo', index:'grupo', width:20, align:'right', search:false, hidden:true, sortable:false}
],
height: "auto",
pager: '#pager2',
rowNum:10,
rowList:[10, 20],
sortname: 'actividad:descripcion',
sortorder: 'asc',
viewrecords: true,
caption: 'Actividades'
});
datatype: 'jsonstring',
datastr : json_acts,
colNames:['Codigo','Descripcion', 'Unidad', 'P. unit.', ' ', 'Grupo'],
colModel :[
{name:'id', index:'actividad:id', width:60, hidden:true},
{name:'descripcion', index:'actividad:descripcion', width:310,editable:true,editrules:{required:true}},
{name:'unidad', index:'actividad.unidad', align:'center', width:60, search:false},
{name:'total', index:'total', width:60, align:'right', search:false, sortable:false,formatter:'number'},
{name:'add', index:'add', width:20, align:'right', search:false, sortable:false,fixed:true},
{name:'grupo', index:'grupo', width:20, align:'right', search:false, hidden:true, sortable:false}
],
height: "auto",
pager: '#pager2',
rowNum:10,
rowList:[10, 20],
sortname: 'actividad:descripcion',
sortorder: 'asc',
viewrecords: true,
caption: 'Actividades'
});
and the json data:
var json_acts = '{"userdata":{"exec_time":"0.1920"},"page":1,"total":45,"records":447,"rows":[{"id":"861","cell":["861","01 DEMOLICION","ITEM",0]},{"id":"726","cell":["726","0101 Desmantelar techo cerchas madera","m2",1191.58056]},{"id":"846","cell":["846","0102 Demolicion pared gypsum","m2",1787.37085]},{"id":"845","cell":["845","0103 Demolicion pared bloque","m2",2264.00304]},{"id":"848","cell":["848","0104 Demolicion cielo internit","m2",2025.68701]},{"id":"849","cell":["849","0106 Demolicion cielo tablilla","m2",2383.16113]},{"id":"850","cell":["850","0202 Botada excavacion manual","m3",2383.16113]},{"id":"575","cell":["575","0204 Excavacion general","m3",6839.67216]},{"id":"945","cell":["945","Accesorios de ba\u00f1o editado fer","Jgo",593.18295]},{"id":"255","cell":["255","Acometida de agua potable","PZA",956.51414]}]}';NOTES:
- Works perfectly on v3.6.2
- Some lines below I change the datatype:"json", and when reloading the grid on page 1, it returns the exact same string
Forum Timezone: Europe/Sofia
Most Users Ever Online: 715
Currently Online:
46 Guest(s)
Currently Browsing this Page:
1 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