public function getBasicListQuery()
{
$query = parent::getBasicListQuery();
$query .= ' INNER JOIN vtiger_blocks ON vtiger_blocks.blockid = vtiger_blocks_hide.blockid INNER JOIN vtiger_tab ON vtiger_tab.tabid = vtiger_blocks.tabid';
return $query;
}
public function getBasicListQuery()
{
$query = parent::getBasicListQuery();
$query .= ' WHERE directly_related_to_role=0 ';
return $query;
}
/**
* Function return only statuses type settings
* @return string
*/
public function getBasicListQuery()
{
$query = parent::getBasicListQuery();
$query .= ' WHERE setting_type=\'statusParam\'';
return $query;
}
public function getBasicListQuery()
{
$query = parent::getBasicListQuery();
$query .= ' WHERE deleted=0 ';
return $query;
}
