jQuery Grid Plugin - jqGrid

Hi,

I am using json datatype.

And I had duble checked that json data is returning complete set of columns exactly same as colModel.

I am using jqGrid 3.5 Alfa 3 js files to show this grid.

jQuery(document).ready(function(){
  
jQuery("#navgrid").jqGrid({
    url:'../lotjson/saveDataFeed.action',
 datatype: "json",
    colNames:['Name','OL','Desig','DOJ','PreGenpactExp','Qualification','Travel','VisaStatus',
    'ReleaseDate','PotentialBackup','CurrentLoc','Open_Relocation','RelocationOptions','PriCompetency',
    'SndCompetency','ProductExp','Regions','KeyAssigPreGenpact','KeyAssigPostGenpact'],
  colModel:[  
   {name:'name',index:'Name',width:90,editable:true,editoptions:{size:10,maxlength:"30"}},
   {name:'ol',index:'OL',width:90,editable:true,editoptions:{size:10,maxlength:"30"}},
   {name:'desig',index:'Desig',width:90,editable:true,edittype:"select",editoptions:{value:"4B:4B;4C:4C;4D:4D;3:3;2:2"}},
   {name:'doj',index:'DOJ',width:190,editable:true,sorttype:"date",formatter:'date', formatoptions:{srcformat:"Y-m-d",newformat:"d-M-Y"}},
   {name:'preGenpactExp',index:'Pre_Genpact_Exp',width:90,editable:true,editoptions:{size:10,maxlength:"30"}},
   {name:'qualification',index:'Qualification',width:90,editable:true,editoptions:{size:10,maxlength:"30"}},
   {name:'travel',index:'Travel',width:90,editable:true,editoptions:{size:10,maxlength:"30"}},
   {name:'visaStatus',index:'Visa_Status',width:90,editable:true,edittype:"select",editoptions:{value:"B1:B1;L1:L1;PetitionWIP:Petition WIP;Appliedfor:Applied for;None:None"}},
   {name:'ReleaseDate',index:'Release_Date',width:190,editable:true,sorttype:"date",formatter:'date', formatoptions:{srcformat:"Y-m-d",newformat:"d-M-Y"}},
   {name:'potentialBkp',index:'Potential_Backup',width:90,editable:true,editoptions:{size:10,maxlength:"30"}},
   {name:'CurrentLoc',index:'Current_Location',width:90,editable:true,editoptions:{size:10,maxlength:"30"}},
   {name:'openRelocation',index:'Open_Relocation',width:60,editable:true,edittype:"checkbox",editoptions: {value:"Yes:No"}},
   {name:'relocationOptins',index:'Relocation_Options',width:90,editable:true,editoptions:{size:10,maxlength:"30"}},
   {name:'priCompetency',index:'Primary_Competency',width:130,editable:true,editoptions:{size:10,maxlength:"30"}},   
   {name:'secondCompetency',index:'Second_Competency',width:130,editable:true,editoptions:{size:10,maxlength:"30"}},
   {name:'prdExperience',index:'Product_Experience',width:120,editable:true,editoptions:{size:10,maxlength:"30"}},
   {name:'Regions',index:'Regions',width:90,editable:true,editoptions:{size:10,maxlength:"30"}},
   {name:'keyAssigPreGenpact',index:'Key_Assignments_Pre_Genpact',width:160,editable:true,editoptions:{size:10,maxlength:"30"}},
   {name:'keyAssigPostGenpact',index:'Key_Assignments_post_Genpact',width:150,editable:true,editoptions:{size:10,maxlength:"30"}}   
  ],
    rowNum:10,
    rowList:[10,20,30],
    imgpath:'../content/images/jq/jqGrid',
    pager: jQuery('#pagernav'),
    sortname: 'id',
    viewrecords: true,
    sortorder: "desc",
    caption:"Navigator",
    editurl:"../lotjson/saveDataFeed.action",
 width:990,
 height:200
}).navGrid('#pagernav',{edit:true,add:true,del:true,search:true,refresh:true})
});

{"page":1,"records":9,"rows":[{"cell":["qwe","qwe","3","2009-01-01 00:00:00.0","agsd","asdfg","asg","PetitionWIP","2009-01-01 00:00:00.0","asdg","asdg","No","asdfg","asg","sadg","asgd","sag","sg","sag"],"id":"10"},{"cell":["adg","asdf","4B","2009-01-01 00:00:00.0","asdf","asdf","asdf","Appliedfor","2009-01-01 00:00:00.0","asdf","asdc","No","ecwe","wce","wec","wve","cew","cew","cwe"],"id":"9"},{"cell":["Srikanth","Exceed","4C","2009-05-04 00:00:00.0","ere","eee","esee","B1","2009-05-04 00:00:00.0","ttttttttrrrrrrrrrgggggg","b","No","ytuuuuuuuuuuuuuuuuuuuuuuuu","d","e","f","g","h","i"],"id":"8"},{"cell":["aaaa","Creted","4D","2009-04-28 00:00:00.0","","","","B1","2009-01-01 00:00:00.0","","","","","","","","","",""],"id":"6"},{"cell":["mn","mjmh","4B","2009-01-01 00:00:00.0","mhg","ftyu","iugg","B1","2009-01-01 00:00:00.0","","nubh","No","","uvu","uvuv","jgvv","uyvguvg","ygcy","uvv"],"id":"5"},{"cell":["Raj","test","4B","2009-04-04 00:00:00.0","5","BE","etwe","B1","2009-04-04 00:00:00.0","","am","Yes","","MIS/Reporting","tty","kty","jty","rt","er"],"id":"4"},{"cell":["Joans","ipi","4D","2009-05-04 00:00:00.0","tutu","tutu","tutu","B1","2009-06-20 00:00:00.0","HRR","tytyty","No","RERE","tutu","tutu","tutu","tuttu","tutu","tutu"],"id":"3"},{"cell":["Santhosh","sd","4C","2009-03-04 00:00:00.0","tRERERERE","sdfqe","sdfwerwerw","B1","2009-03-04 00:00:00.0","WWW","lkjl","Yes","FWFW","nyt","myjq","vght","rerte","dger","dfgher"],"id":"2"},{"cell":["Kwwey","aaaa","2","2009-01-01 00:00:00.0","2","BE","","L1","2009-01-01 00:00:00.0","EWWE","","Yes","RWRW","Scorecard","Scorecard","Loans","Latam","",""],"id":"1"}],"total":2}

I can't insert image into this post and my server is not accessble from outside.

What type of URL it is expected on link image on this editor.