jQuery Grid Plugin - jqGrid - Topic: Help changing from subgrid to grid as subgrid

Jim P on Help changing from subgrid to grid as subgrid

Wed, 11 Feb 2009 10:14:35 +0200

Tony,

I solved my problem by added a second jsonReader into the deifinition of the subGrid. I was following the example in the documentation (Oct 08)-page 87.

Perhaps you need to revise that example to show the jsonReader in that subGrid code block.

Thanks, Jim

tony on Help changing from subgrid to grid as subgrid

Wed, 11 Feb 2009 00:21:41 +0200

Hello,

You should check what you return from server. When you move from subgrid to grid as subgrid you should synchronoze the jsonRedear of the subgrid. The subgrid properties of the main grid in this case does not have sense.

Regards

Tony

Jim P on Help changing from subgrid to grid as subgrid

Tue, 10 Feb 2009 09:10:14 +0200

OK, I solved the sytax problem: Now my subgrid in a grid headings show up nut not the data. Firebug shows valid json subgrid data being returned but it's not showing in the grid. Do I need to change the json reader values?

Please help. thanks - Jim

       subgrid_table_id = subgrid_id+"_t";
          jQuery("#"+subgrid_id).html("<table id='"+subgrid_table_id+"' class='scroll'></table>");
          jQuery("#"+subgrid_table_id).jqGrid({
            url:"Users.cfc?method=GetSubCases&x_object_id="+rowdata.x_object_id,
              datatype: "json",
                 colNames: ['Subcase ID','Create D/T','Category','Priority','Status','Description'],
              colModel: [
              {name:"x_object_id",index:"x_object_id",width:80,key:true},
              {name:"x_creation_dt",index:"x_creation_dt",width:130},
              {name:"x_category",index:"x_category",width:80,align:"right"},
                 {name:"x_priority",index:"x_priority",width:80,align:"right"},
              {name:"x_status",index:"x_status",width:100,align:"right",sortable:false},
     {name:"x_title",index:"x_title",width:100,align:"right",sortable:false}
                        ],
       height: 100,
             rowNum:20,
             imgpath: 'themes/coffee/images', //Image path for prev/next etc images,
             sortname: 'num',
             sortorder: "asc"
        })
       },

  //  subGridUrl: 'Users.cfc?method=GetSubCases', //CFC that will return the users
  //  subGridModel: [{
  //     name: ['SubCase No','Priority','Creation Date','Problem'], //Column Names
  //     width: [100, 100, 175, 300],
  //     params: ['x_object_id']}
  //  ],

    //The JSON reader. This defines what the JSON data returned from the CFC should look like
    jsonReader: {
     root: "ROWS",
     page: "PAGE",
     total: "TOTAL",
     records:"RECORDS",
     cell: "",
     id: "0",
     subgrid: {root: "ROWS", repeatitems: true, cell: "",id:"0"}
     }
    }
   );

  }
); // end of document ready

$("#t_list").css("color","red");
//

</script>

Jim P on Help changing from subgrid to grid as subgrid

Mon, 09 Feb 2009 14:51:40 +0200

I got my subgrid working. Now I want to change the subgrid to a Grid as s Subgrid.

I get the following error:

<script src="jquery.js" type="text/javascript"></script>
<script src="jquery.jqGrid.js" type="text/javascript"></script>
<script src="js/jqModal.js" type="text/javascript"></script>
<script src="js/jqDnR.js" type="text/javascript"></script>

// problem is in this code - if commented out it works fine

    subGridRowExpanded: function(subgrid_id, row_id) {
      // we pass two parameters
       // subgrid_id is a id of the div tag created within a table
       // the row_id is the id of the row
    // If we want to pass additional parameters to the url we can use
    // the method getRowData(row_id) - which returns associative array in type name-value
       // here we can easy construct the following
       var subgrid_table_id;
       subgrid_table_id = subgrid_id+"_t";
        jQuery("#"+subgrid_id).html("<table id='"+subgrid_table_id+"' class='scroll'></table>");
            jQuery("#"+subgrid_table_id).jqGrid({
           url:"Users.cfc?method=GetSubCases&q=2&id="+row_id,
            datatype: "xml",
            colNames: ['Subcase ID','Create D/T','Category','Priority','Statusl','Description'],
            colModel: [
              {name:"x_object_id",index:"x_object_id",width:80,key:true},
              {name:"x_creation_dt",index:"x_creation_dt",width:130},
              {name:"x_category",index:"x_category",width:80,align:"right"},
             {name:"x_priority",index:"x_priority",width:80,align:"right"},
              {name:"x_status",index:"x_status",width:100,align:"right",sortable:false},
     {name:"x_title",index:"x_title",width:100,align:"right",sortable:false}
                         ],
     height: 100%,
              rowNum:20,
             imgpath: gridimgpath,
             sortname: 'num',
             sortorder: "asc"
        }
  //  subGridUrl: 'Users.cfc?method=GetSubCases', //CFC that will return the users
  //  subGridModel: [{
  //     name: ['SubCase No','Priority','Creation Date','Problem'], //Column Names
  //     width: [100, 100, 175, 300],
  //     params: ['x_object_id']}
  //  ],

</script>

</head>

<body>

syntax error

height: 100%,\\n

Here's my code. Any help would be appreciated - Jim