How to make a search query for max and min in symfony 4?

1
2

use DoctrineORMEntityManagerInterface;
use DoctrineORMQueryBuilder;

1
2
3
4
5
6

private $entityManager;

public function __construct(EntityManagerInterface $entityManager)
{
    $this->entityManager = $entityManager;
}

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17

public function searchMinMax()
{
    $queryBuilder = $this->entityManager->createQueryBuilder();
    
    $query = $queryBuilder
        ->select('MAX(entity.field) as maximum, MIN(entity.field) as minimum')
        ->from(EntityName::class, 'entity')
        ->getQuery();

    $result = $query->getOneOrNullResult();

    // Access the maximum and minimum values
    $maximum = $result['maximum'];
    $minimum = $result['minimum'];
    
    // ...
}