protected function getSortTokens(PlFilter $uf) { $sub = $uf->addDisplayFilter(); $token = 'pd.sort_name'; if ($uf->accountsRequired()) { $account_token = Profile::getAccountEquivalentName('sort_name'); return 'IFNULL(' . $token . ', a.' . $account_token . ')'; } else { return $token; } }
public function buildCondition(PlFilter $uf) { $table = 'sort_name'; if ($uf->accountsRequired()) { $table = Profile::getAccountEquivalentName($table); $sub = 'a'; } else { $uf->addDisplayFilter(); $sub = 'pd'; } return 'SUBSTRING(' . $sub . '.' . $table . ', 1, 1) ' . XDB::formatWildcards(XDB::WILDCARD_PREFIX, $this->initial); }