Filtering a reports recordset

PHPMaker General Discussion (PHPMaker)
1

hI,

can’t find a function where we can filter out a reports recordset, so that only the current users records are selected.

is this possible in a report?, the data is coming from a view, we are able to get the lookups to filter no problem via lookupSelecting(), but can’t filter the recordset

could probably do it via pageFilterLoad(), pageFilterValidated() but not sure that’s the best way – or if it is the only way…

thanks,

2

found the tableLoad() which does the trick, but there is no entry in phpMaker [Table Specific] Summary Report to enter the code ??

// Table Load event
public function tableLoad()
{
    // Enter your code here
    $tenantKey = _getUserInfo("tenantId", CurrentUserID());
    $tenantId = _getBusinessInfo("tenantId",$tenantKey);
    
    $this->setSqlWhere("tenantId='$tenantKey'");
}
3

For reports, you may try Page_Selecting.

4

thanks, that worked in the pageSelecting().