sample 1
$pager = new PagerAdvSearch($xpage, $xlimit, false);
$pager->link_id = $link_id;
$pager->use_mod = true;

$join_connector = $link_id->lstv_dbtype=="my" ? "":"dbo.";


$pager->mod_query = " {$link_id->lstv_dbname}.{$join_connector}postypefile as pos
INNER JOIN {$link_id->lstv_dbname}.{$join_connector}pricecodefile1 as prc1
on pos.postypcde = prc1.postypcde
INNER JOIN {$link_id->lstv_dbname}.{$join_connector}warehousefile as war
on prc1.warcde = war.warcde";

$pager->mod_fields = "pos.postypdsc as postypdsc,
                        prc1.prccde as prccde,
                        prc1.brhcde as brhcde,
                        war.wardsc as warcde,
                        prc1.curcde as curcde";
                

$pager->debug = false;
$pager->mod_table_id = "prc1.recid";	
$pager->title = "Price List";
$pager->link_id = $link_id;
$pager->table = 'pricecodefile1';
$pager->table_id = 'recid';
$pager->headers = $xarr_hdr; //&z
$pager->header_width = array(1,40,25);

//////////////////////////////////////////////////////////////////////////////////////////////////////////////////

sample 2
$pager = new Pager($xpage,$xlimit,false);
$pager->title = "Setup Item Minimum Price";
$pager->link_id = $link_id;
$pager->use_mod=true;
$pager->debug = false;
$pager->mod_query=" itemunitfile as u
                    Inner Join itemfile as i
                    on  u.itmcde =  i.itmcde ";
$pager->mod_table_id="u.recid";
$pager->mod_fields=" u.itmcde , u.untmea, u.untcst, u.untprc, u.minselprc,i.itmdsc, i.itmnum";

$pager->table = 'itemunitfile as u';
$pager->table_id = 'recid';


//////////////////////////////////////////////////////////////////////////////////////////////////////////////////

sample 3
$pager = new Pager($xpage, $xlimit, false);
$pager->title = "Cash Advances $xpager_add_title";
$pager->use_mod = true;
$pager->debug = false;

$join_connector = $link_id->lstv_dbtype=="my" ? "":"dbo.";

$pager->mod_query = " {$link_id->lstv_dbname}.{$join_connector}borrowersfile as bor
						INNER JOIN {$link_id->lstv_dbname}.{$join_connector}appaymentsfile2 as appay2
						on bor.borcde = appay2.borcde";

$pager->mod_fields= "	bor.bordsc as bordsc,
						appay2.brhcde as brhcde,
						appay2.trndte as trndte,
						appay2.docnum as docnum,
						appay2.refnum as refnum,
						appay2.curcde as curcde,
						appay2.amountfor as amountfor,
						appay2.canceldoc as canceldoc,
						appay2.trncde as trncde,
						appay2.dirliq as dirliq,
						appay2.ewt as ewt,
						appay2.borcde as borcde";

$pager->link_id = $link_id;
$pager->mod_table_id = "appay2.recid";
$pager->table = 'appaymentsfile2';
$pager->table_id = 'recid';
$pager->headers = $xarr_headers; //&z
$pager->fields = $xarr_fields;