How to convert this to Doctrine 2 QueryBuilder format?

by

try this :

1) create your subquery

$subquery = $this->_em->createQueryBuilder()
    ->select('t.id')
    ->from('yourBundle:Task', 't')
    ->innerjoin('t.user','u')
    ->where('u.id = 1')
    ->getDQL();

2) after create your query

$query = $this->_em->createQueryBuilder();
$query->select('l')
      ->from('yourBundle:Layer', 'l')
      ->where($query->expr()->notIn('l.id', $subquery))
      ....;

I tested it and it works 🙂

More Related Contents:

  1. Count Rows in Doctrine QueryBuilder
  2. Using Relationships with Multiple Entity Managers
  3. symfony2: how to use group_concat in QueryBuilder
  4. The EntityManager is closed
  5. Symfony 2: Creating a service from a Repository
  6. Symfony2 and Doctrine – Error: Invalid PathExpression. Must be a StateFieldPathExpression
  7. How to configure naming strategy in Doctrine 2
  8. Primary key of owning side as a join column
  9. Should everything really be a bundle in Symfony 2.x?
  10. On delete cascade with doctrine2
  11. How do I read configuration settings from Symfony2 config.yml?
  12. How to encode Doctrine entities to JSON in Symfony 2.0 AJAX application?
  13. How can I run symfony 2 run command from controller
  14. Symfony2: how to log user out manually in controller?
  15. How to set up entity (doctrine) for database view in Symfony 2
  16. How to specify the scope of Google API to get the birthday
  17. There is no extension able to load the configuration for “facebookbundle” symfony2
  18. How can I deploy Symfony in a subdirectory?
  19. How does the login check_path route work without default controller/action?
  20. How to get config parameters in Symfony2 Twig Templates
  21. How to check if a user is logged in Symfony2 inside a controller?
  22. Doctrine – A new entity was found through the relationship
  23. Symfony 2.0 getting service inside entity
  24. Doctrine query builder using inner join with conditions
  25. How to force Doctrine to update array type fields?
  26. Twig: render vs include
  27. How do I get the user IP address in Symfony2 controller?
  28. Memory leaks Symfony2 Doctrine2 / exceed memory limit
  29. Query on a many-to-many relationship using Doctrine with Symfony2
  30. How to add custom link or button to SonataAdminBundle Dashboard in Symfony2

Leave a Comment