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