jQuery Grid Plugin - jqGrid - Topic: django and Jqgrid issue http://www.trirand.com/blog/?page_id=393/discussion/django-and-jqgrid-issue Simple:Press Version 5.7.5.3 ashish on django and Jqgrid issue http://www.trirand.com/blog/?page_id=393/discussion/django-and-jqgrid-issue#p3349 Discussion http://www.trirand.com/blog/?page_id=393/discussion/django-and-jqgrid-issue#p3349 Thanks,using [] instead of {} was the problem. It is working now. Please get the docs fixed as I changed {} to [] to match the docs.

]]> Fri, 28 Nov 2008 13:06:31 +0200 tony on django and Jqgrid issue http://www.trirand.com/blog/?page_id=393/discussion/django-and-jqgrid-issue#p3347 Discussion http://www.trirand.com/blog/?page_id=393/discussion/django-and-jqgrid-issue#p3347 Hello,

I'm very sorry for this - it is docs bug - you should  set this way

{total:”1″, page:”1″, records:”2″,rows:[ { id:18,"status": "New", "due_date": "11/20/08", "task_type": "Defect", "severity": "Medium", "estimated_effort": 35, "task_no": 18, "task_summary": "backlog defect", "sprint_id": 3, "actual_effort_so_far": 5, "milestone": "Test Iteration", "owner": "R barron", "open_date": "11/09/08", "effort_remaining": 30 }...]

See the bolded symbols

It will be corrected as soon as possible.

Regards

Tony

]]> Fri, 28 Nov 2008 11:30:05 +0200 ashish on django and Jqgrid issue http://www.trirand.com/blog/?page_id=393/discussion/django-and-jqgrid-issue#p3346 Discussion http://www.trirand.com/blog/?page_id=393/discussion/django-and-jqgrid-issue#p3346 I tried all that , still no data, it shows the header and footer of grid and loading message but no data,

I added jsonmap, tried with id="0" and id="id" , I am doing some simple mistake... Is there a way to debug on client side why jqgrid does not like what I am sending..

Here is my jqgrid js , followed by data

jQuery(document).ready(function(){ 

  jQuery("#list").jqGrid({

    url:'/viewalltasks/',

    datatype: 'json',

    mtype: 'POST',

    colNames:['Id','Task', 'Status','Owner','Due Date'],

    colModel :[ 

      {name:'id', index:'id',jsonmap:'id', width:55}, 

      {name:'task_no', index:'task_no',jsonmap:'task_no', width:55}, 

      {name:'status', index:'status', jsonmap:'status', width:80, align:'right'}, 

      {name:'owner', index:'owner', jsonmap:'owner',width:80, align:'right'}, 

      {name:'due_date', index:'due_date', index:'due_date',jsonmap:'due_date',width:80, align:'right'}], 

    pager: jQuery('#pager'),

    jsonReader:{

        root: "rows",

        repeatitems: false,

        id: "id"

    },

    rowNum:5,

    rowList:[5,10,20],

    sortname: 'id',

    sortorder: 'asc',

    viewrecords: true,

    imgpath: 'themes/basic/images',

    caption: 'My first grid',

    height:210,

    toolbar: [true,'top']

  }); 

}); 

json data

{total:"1", page:"1", records:"2",rows:[[id:18,"status": "New", "due_date": "11/20/08", "task_type": "Defect", "severity": "Medium", "estimated_effort": 35, "task_no": 18, "task_summary": "backlog defect", "sprint_id": 3, "actual_effort_so_far": 5, "milestone": "Test Iteration", "owner": "R barron", "open_date": "11/09/08", "effort_remaining": 30],[id:27,"status": "New", "due_date": "11/21/08", "task_type": "Defect", "severity": "High", "estimated_effort": null, "task_no": 27, "task_summary": "what apain", "sprint_id": 3, "actual_effort_so_far": 0, "milestone": "Test Iteration", "owner": "R barron", "open_date": "11/09/08", "effort_remaining": null]]}

]]> Fri, 28 Nov 2008 11:12:49 +0200 tony on django and Jqgrid issue http://www.trirand.com/blog/?page_id=393/discussion/django-and-jqgrid-issue#p3341 Discussion http://www.trirand.com/blog/?page_id=393/discussion/django-and-jqgrid-issue#p3341 Hello,

I think you should configure jsonReader for this purpose and change

a little the returned data:

Try this

jsonReader: {

root : "rows",

repeatitems : false,

id: "id"

}

configure the jsonmap in the colModel and then return this:

{total:”1″, page:”1″, records:”2″,  rows: [ [ id:18 ,"status": "New", "due_date": "11/20/08", "task_type": "Defect", "severity": "Medium", "estimated_effort": 35, "task_no": 18, "task_summary": "backlog defect", "sprint_id": 3, "actual_effort_so_far": 5, "milestone": "Test Iteration", "owner": "R barron", "open_date": "11/09/08", "effort_remaining": 30, "id": 18 ], ....]

Also refer to docs how to configure this

]]> Fri, 28 Nov 2008 02:43:23 +0200 ashish on django and Jqgrid issue http://www.trirand.com/blog/?page_id=393/discussion/django-and-jqgrid-issue#p3335 Discussion http://www.trirand.com/blog/?page_id=393/discussion/django-and-jqgrid-issue#p3335 I am trying to use jqgrid and it does not like the data format my django view is returning. Please help.

json data:

{total:"1", page:"1", records:"2", rows: [[id:18, cell:["status": "New", "due_date": "11/20/08", "task_type": "Defect", "severity": "Medium", "estimated_effort": 35, "task_no": 18, "task_summary": "backlog defect", "sprint_id": 3, "actual_effort_so_far": 5, "milestone": "Test Iteration", "owner": "R barron", "open_date": "11/09/08", "effort_remaining": 30, "id": 18]],[id:27, cell:["status": "New", "due_date": "11/21/08", "task_type": "Defect", "severity": "High", "estimated_effort": null, "task_no": 27, "task_summary": "what apain", "sprint_id": 3, "actual_effort_so_far": 0, "milestone": "Test Iteration", "owner": "R barron", "open_date": "11/09/08", "effort_remaining": null, "id": 27]]]}

javascript:

here is the js. I see the header and footer of grid but no data

jQuery(document).ready(function(){
  jQuery("#list").jqGrid({
    url:'/viewalltasks/',
    datatype: 'json',
    mtype: 'POST',
    colNames:['Id','Task', 'Status','Owner','Due Date'],
    colModel :[
      {name:'task_no', index:'task_no', width:55},
      {name:'task_summary', index:'task_summary', width:90},
      {name:'status', index:'status', width:80, align:'right'},
      {name:'owner', index:'owner', width:80, align:'right'},
      {name:'due_date', index:'due_date', width:80, align:'right'}],
    pager: jQuery('#pager'),
    jsonReader:{
  root: "row",
  page: "page",
  total: "total",
  records: "records",
  repeatitems: false,
  id: "id"
},
    rowNum:10,
    rowList:[10,20,30],
    sortname: 'id',
    sortorder: "status",
    viewrecords: true,
    imgpath: 'themes/basic/images',
    caption: 'My first grid'
  });
});

]]> Thu, 27 Nov 2008 16:33:13 +0200