Symfony 2 DQL query

Question

I have this query in Symfony 2. It works great but I was wondering if it was possible to make something cleaner.

I'm new to Symfony and QueryBuilder and I couldn't get to do something that works with the queryBuilder.

$em = $this->getEntityManager();
    $query = $em->createQuery(
    'SELECT t '.
    'FROM MyBundle:Task t '.
    'WHERE t.folder IN '.
            '(SELECT f.id '.
            'FROM MyBundle:Folder f '.
            'WHERE f.priority = '.$prio.
            ' AND f.user IN '.
              '(SELECT u.id '.
                'FROM MyBundle:User u '.
                'WHERE u.id ='.$user->getId().'))');

The scheme is simple A User has Many Folders, a Folder has many Tasks and I m looking for all tasks for one user.

Thanks a lot !

mohsenJsh · Accepted Answer · 2014-06-19 14:30:37Z

2

do you have entity relation for this three entity? if yes try this

$em->createQuery('SELECT t FROM MyBundle:Task t'
                . 'JOIN t.folder f'
                . 'JOIN f.user u'
                . 'WHERE u.id=:id')
                ->setParameter('id', $user->getId());

answered Jun 19, 2014 at 14:30

mohsenJsh

2,1183 gold badges25 silver badges54 bronze badges

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

3 Comments

jmc Over a year ago

Thanks a lot ! I just had to add some spacings and a parameter for the priority but it works.

qooplmao Over a year ago

Or with the builder

$em->createQueryBuilder('t')->join('t.folder', 'f')->join('f.user', 'u')->where('u.id', ':id')->setParameter('id', $user->getId())

jmc Over a year ago

I had to rearrange it a little bit but thanks to you I learned a bit more about this kind of syntax. The right syntax for the where is where('u.id = :id') Thanks ;-)

Collectives™ on Stack Overflow

Symfony 2 DQL query

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related