public function findAllSortedBy($field, $limit = null)
{
$query = $this->createQueryBuilder('u')->orderBy('u.' . $field, 'name' === $field ? 'asc' : 'desc')->getQuery();
if (null !== $limit) {
$query->setMaxResults($limit);
}
return $query->execute();
}