Doctrine why doesn't dql work, what am I doing wrong?

Question

symfony

$query = $entityManager->createQuery(
            'SELECT MAX(employee.salary) FROM
                AppBundle:Employee employee
                JOIN  AppBundle:Department department
                WHERE department.id = :id'
        )->setParameter('id', $department->getId());

        $result = $query->getSingleScalarResult();

for some reason it ignores the department.id = :id comparison, and always returns the result .
$department->getId() which is equal to 32 should only get the result, because it has an employee and nowhere else. How to do this?

Answer 1

You're asking incorrectly. It should look something like this (I assume you have a @ManyToOne relationship configured between Employee and Department):

SELECT MAX(employee.salary)
FROM AppBundle:Employee employee
JOIN employee.department department
WHERE department.id = :id

Can be done without connections if you use the IDENTITY DQL function:

SELECT MAX(employee.salary)
FROM AppBundle:Employee employee
WHERE IDENTITY(employee.department) = :id