Subquery in doctrine2 notIN Function

by

The same alias cannot be defined 2 times in the same query

$qb  = $this->_em->createQueryBuilder();
$qb2 = $qb;
$qb2->select('m.id')
    ->from('Custom\Entity\MembreService', 'ms')
    ->leftJoin('ms.membre', 'm')
    ->where('ms.id != ?1');

$qb  = $this->_em->createQueryBuilder();
$qb->select('mm')
    ->from('Custom\Entity\Membre', 'mm')
    ->where($qb->expr()->notIn('mm.id', $qb2->getDQL())
);
$qb->setParameter(1, $service);
$query  = $qb->getQuery();

return $query->getResult();

Ideally you should use many-to-many relation for your entity, in this case your query is going to be much simpler.

More Related Contents:

  1. How to use WHERE IN with Doctrine 2
  2. Select entries between dates in doctrine 2
  3. Join subquery with doctrine 2 DBAL
  4. Doctrine2: Best way to handle many-to-many with extra columns in reference table
  5. Is there a built-in way to get all of the changed/updated fields in a Doctrine 2 entity
  6. On delete cascade with doctrine2
  7. Why I am suddenly getting a “Typed property must not be accessed before initialization” error when introducing properties type hints?
  8. How to do left join in Doctrine?
  9. Default value in Doctrine
  10. Doctrine 2 and Many-to-many link table with an extra field
  11. How to select randomly with doctrine
  12. Should I use EAV model?
  13. Too much data with var_dump in symfony2 doctrine2
  14. How to re-save the entity as another row in Doctrine 2
  15. Cakephp-3.x: How to change the data type of a selected alias?
  16. Injecting SecurityContext into a Listener prePersist or preUpdate in Symfony2 to get User in a createdBy or updatedBy Causes Circular Reference Error
  17. How to set up entity (doctrine) for database view in Symfony 2
  18. Symfony2, Dynamic DB Connection/Early override of Doctrine Service
  19. How to get a one-dimensional scalar array as a doctrine dql query result?
  20. How to setup table prefix in symfony2
  21. How to use a findBy method with comparative criteria
  22. Symfony 2.0 getting service inside entity
  23. “Class XXX is not a valid entity or mapped super class” after moving the class in the filesystem
  24. Can I access discriminator field from php in doctrine2?
  25. How to force Doctrine to update array type fields?
  26. Query on a many-to-many relationship using Doctrine with Symfony2
  27. Doctrine2 association mapping with conditions
  28. How can I use DATE() in Doctrine 2 DQL?
  29. fetch data inmultidimensional array in PHP [closed]
  30. How to add a view helper directory (zend framework)

Leave a Comment