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; }