jQuery Grid Plugin - jqGridForum

Topic RSS

Create/Update Grid using a Link from A different Grid

21/12/2010
18:16

mrh

Member

Members

Forum Posts: 3

Member Since:
21/12/2010

Offline

Hi,

I have two functions that create two different grids on a page. The first grid loads and has unique URLs which use an onclick function call to create another grid on the page. This works very well for the first grid, however when I click on another URL from the first grid it does not reload the second grid with the new data. I have tried variations of (reloadGrid) but it's just not working for me.

Essentially what I am trying to do is when a link is clicked in Grid 1 it updates Grid 2 with new data. Your help is greatly appreciated.

Here are my functions. The "buildTable1" function is called from a <body onload> event. The "buildTable2" function is run when a link is clicked from Table 1 (and like I say, the first Table 2 grid is built fine, but not the others.

function buildTable1(idnum){
jQuery("#table1").jqGrid(
{
   url:'inc/tables.php?do=funct1&idnum='+idnum,
   datatype: "json",
   mtype: 'GET',
   colNames:['Manager Name','Division','Region','View Team'],
   colModel:[
                  {name:'name',index:'name', width:120, align:"center", search: false },
                  {name:'division_code',index:'division_code', width:90, align:"center", searchoptions: { sopt:['cn'] } },
                  {name:'region_code',index:'region_code', width:90, align:"center", searchoptions: { sopt:['cn'] } },
                  {name:'emp_id',index:'emp_id', width:70, align:"center",sortable: false, search: false }
   ],
   sortname: 'division_code',
   sortorder: "asc",
   rowNum:50,
   pager: '#table1-pager',
   viewrecords: true,
   caption:"Manager List North America",
   width: 399,
   height: 'auto' });
   jQuery("#table1").jqGrid('navGrid','#table1-pager',{
       edit:false,
       add:false,
       del:false });
}

My next function is like this which is called from a link in Table 1.

The link in Table 1 looks something like this. onclick="buildTable2(id);"

function buildTable2(id){
   jQuery("#table2").jqGrid( {

   url:'inc/tables.php?do=funct2&idnum='+idnum,
   datatype: "json",
   mtype: 'GET',
   colNames:['Name','ID','Division','Region','Phone'],
   colModel:[
               {name:'name',index:'name', width:120, align:"center", search: false },
               {name:'id',index:'id', width:70, align:"center",sortable: false, search: false },
               {name:'division_code',index:'division_code', width:90, align:"center", searchoptions: { sopt:['cn'] } },
               {name:'region_code',index:'region_code', width:90, align:"center", searchoptions: { sopt:['cn'] } },
               {name:'phone_number',index:'phone_number', width:120, align:"center", search: false }
],
   sortname: 'name',
   sortorder: "asc",
   rowNum:50,
   pager: '#table2-pager',
   viewrecords: true,
   caption:"Team List",
   width: 680,
   height: 'auto' });
   jQuery("#table2").jqGrid('navGrid','#table2-pager',{
       edit:false,
       add:false,
       del:false });

}

I like to put my filters as links in the tables which will then reload the data. I used to do this purely in PHP but I wanted to start using JQGRID so I am evaluating this but stuck at this point.

Thanks

21/12/2010
19:09

mrh

Member

Members

Forum Posts: 3

Member Since:
21/12/2010

Offline

I have tried using the .trigger("reloadGrid") method but still only the first table 2 is loaded. Subsequent link clicks does not reload the tbale with new data.

All RSS

Forum Timezone: Europe/Sofia

Most Users Ever Online: 715

Currently Online:
56 Guest(s)

Currently Browsing this Page:
1 Guest(s)