nextcloud / server

			->from('groups')

			->orderBy('gid', 'ASC');

		if ($search !== '') {

			$query->where($query->expr()->iLike('gid', $query->createNamedParameter(

				'%' . $this->dbConn->escapeLikeParameter($search) . '%'

			)));

		}

		$query->setMaxResults($limit)

			->setFirstResult($offset);

			->where($query->expr()->eq('gid', $query->createNamedParameter($gid)))

			->orderBy('uid', 'ASC');

		if ($search !== '') {

			$query->andWhere($query->expr()->like('uid', $query->createNamedParameter(

				'%' . $this->dbConn->escapeLikeParameter($search) . '%'

			)));

		}

		$query->setMaxResults($limit)

			->setFirstResult($offset);

			->from('group_user')

			->where($query->expr()->eq('gid', $query->createNamedParameter($gid)));

		if ($search !== '') {

			$query->andWhere($query->expr()->like('uid', $query->createNamedParameter(

				'%' . $this->dbConn->escapeLikeParameter($search) . '%'

			)));

		}

		$result = $query->execute();

		$count = $result->fetchColumn();