Compare a count of subquery with scalar

Question

I'm using Symfony 4.3 and I have a problem in my DQL query.

The purpose of my query is to select email of user how have list of right for this is my DQL query:

        $qb = $this->createQueryBuilder('u')
        ->select('u.email,u.id')
        ->leftJoin('u.profile', 'profile')
        ->leftJoin('u.country', 'country')
        ->leftJoin('profile.privileges', 'pri')
        ->leftJoin('pri.ressource', 'resource')
        $checkRightQuery = $this->em->createQueryBuilder()
            ->select('count(rc)')
            ->from(Ressource::class, 'rc')
            ->leftJoin('rc.privileges', 'privil')
            ->leftJoin('privil.profile', 'prof')
            ->leftJoin('prof.user', 'user')
            ->where( $this->em->getExpressionBuilder()->in('rc.actionFront', ':rights'))
            ->andWhere('user.id =u.id');
        $qb->andWhere(
            $this->em->getExpressionBuilder()->eq(count($rights),
                $checkRightQuery
            )
        );

    $qb->setParameters(['rights' => $rights]);

The problem is when I take the result of the count it's not a scalar and it can't compare it to scalar.

Any help please?

Answer 1

Try using parenthesis on your condition with the subquery:

$qb->andWhere(
        $this->em->getExpressionBuilder()->eq(count($rights),
            '(' . $checkRightQuery . ')'
        )
    );

References

Doctrine return error with “eq”, no with “in”