/** * */ public function get_search_sql($search) { global $USER; $state = $search[3]; // State may be searched by name. $statekey = array_search($state, $this->states); if ($statekey !== false) { $search[3] = $statekey; return parent::get_search_sql($search); } // State may be searched by index. if (is_numeric($state) and $state < count($this->states)) { return parent::get_search_sql($search); } return null; }