Doctrine2 DQL issue with COUNT = 0

Question

I have the following query so far:

   $shopQuery = $qb->select('DISTINCT u')
                    ->from("BlahUserBundle:User", 'u')
                    ->innerJoin('u.followers', 'followers')
                    ->andWhere('followers.id != :userId')
                    ->setParameter('userId', $user->getId())
                    ->orWhere('') //or where those user who doesn't have a follower yet
                    //->setMaxResults(5)
                    ;

I am trying to find a way to query all users who doesn't have a follower and whose follower is not my self (in this case my self is $user->getId()). How do I do so?

If you use an innerJoin you won't get the result you want because, if a user doesn't have a follower you won't get that row. I think you need a subQuery for this. Let me think about it :) — Pi Wi
– Pi Wi, Commented Nov 15, 2013 at 8:57
@Pi Wi is right, but you may replace your inner join by a left join to match both results. — Boris Guéry
– Boris Guéry, Commented Nov 15, 2013 at 9:06

Pi Wi · Accepted Answer · 2013-11-15 09:32:34Z

1

Try this

$shopQuery = $qb->from("BlahUserBundle:User", 'u')
            ->leftJoin(
                'u.followers',
                'followers',
                'on',
                'followers.id != :userId'
            )
            ->where('followers.id IS NULL')
            ->setParameter('userId', $user->getId());
$shopQuery->getQuery()->getResults();

answered Nov 15, 2013 at 9:32

Pi Wi

1,0851 gold badge11 silver badges20 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Doctrine2 DQL issue with COUNT = 0

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related