User management: search in more attributed (displayname, email)

[rullzer]

It would be good if search/filter would work on the user management page. To quickly locate users.

CC: @skjnldsv

[skjnldsv]

Comes from php!

server/apps/provisioning_api/lib/Controller/UsersController.php

Line 127 in f5137fe

public function getUsers(string $search = '', $limit = null, $offset = 0): DataResponse {

[skjnldsv]

Hum, we can already search by email/displayName/uid

server/lib/private/User/Database.php

Lines 266 to 278 in 145eee9

	$query->select('uid', 'displayname')
	->from($this->table, 'u')
	->leftJoin('u', 'preferences', 'p', $query->expr()->andX(
	$query->expr()->eq('userid', 'uid'),
	$query->expr()->eq('appid', $query->expr()->literal('settings')),
	$query->expr()->eq('configkey', $query->expr()->literal('email')))
	)
	// sqlite doesn't like re-using a single named parameter here
	->where($query->expr()->iLike('uid', $query->createPositionalParameter('%' . $this->dbConn->escapeLikeParameter($search) . '%')))
	->orWhere($query->expr()->iLike('displayname', $query->createPositionalParameter('%' . $this->dbConn->escapeLikeParameter($search) . '%')))
	->orWhere($query->expr()->iLike('configvalue', $query->createPositionalParameter('%' . $this->dbConn->escapeLikeParameter($search) . '%')))
	->orderBy($query->func()->lower('displayname'), 'ASC')
	->orderBy('uid_lower', 'ASC')

[MorrisJobke]

Fixing search in groups could be solved in #21138