Thanks for all your help.

Thanks for all your help.

url:'dailyPL.action?q=2',
    datatype: “json”,   

Can you please point me to what am I missing.

For this kind of data you need to configure the jsonReader.

Refer to documentation how to do that.

Regards

Tony

Thanks for all your hard work and support for open community. I am trying to get a sample working but getting weird error cur is undefined. Can you please help me resolve the problem.

  jQuery("#list").jqGrid({
    url:'dailyPL.action?q=2',
    datatype: "json",   
    colNames:['ID','Ticker','Delivery Date', 'Maturity Date', 'Unrealized PL','Realized PL'],
    colModel:[
            {name:'id',index:'id', width:55},           
               {name:'ticker',index:'ticker', width:100},
               {name:'deliveryDate',index:'deliveryDate', width:90, sorttype:"int"},
               {name:'maturityDate',index:'maturityDate', width:100},
               {name:'unrealized',index:'unrealized', width:80, align:"right"},
               {name:'realized',index:'realized', width:80, align:"right"}       
           ],
    pager: jQuery('#pager'),
    rowNum:10,
    rowList:[10,20,30],
    sortname: 'id',
    sortorder: "desc",
    viewrecords: true,  
    imgpath: 'themes/basic/images',
    caption: 'My first grid'
  });

{"page":"1","records":"3","rows":[{"deliveryDate":20080950,"id":"1","maturityDate":20080602,"realized"

:0.0,"ticker":"GE","unrealized":500.0},{"deliveryDate":20080950,"id":"2","maturityDate":20080602,"realized"

:0.0,"ticker":"cSC","unrealized":5000.0},{"deliveryDate":20080950,"id":"3","maturityDate":20080602,"realized"

:0.0,"ticker":"MAGNA","unrealized":6900.0}],"total":1.0}

Appreciate a lot. Thanks for your help.