/** * Functions returns the query * @return string */ public function getQuery() { $listQuery = parent::getQuery(); //remove the status active condition since in users list view we need to consider inactive users as well $listQueryComponents = explode(" WHERE vtiger_users.status='Active' AND",$listQuery); $listQuery = implode(' WHERE ', $listQueryComponents); return $listQuery; }
/** * Functions returns the query * @return string */ public function getQuery() { $listQuery = parent::getQuery(); //remove the status active condition since in users list view we need to consider inactive users as well $searchKey = $this->get('search_key'); if (!empty($searchKey)) { $listQueryComponents = explode(" WHERE vtiger_users.status='Active' AND", $listQuery); $listQuery = implode(' WHERE ', $listQueryComponents); } return $listQuery; }