Using an Inner Join with QueryBuilder on Symfony2

Question

I want to use an inner Join for my tables auto and rent('s'). Its an 1:N relationship. If I use ->innerJoin('s', 'a') it comes to some errors like this:

[Semantical Error] line 0, col 62 near 's a, ChrisKfzBuchungBundle:Auto': Error: Class 's' is not defined.

$repo = $this->getDoctrine()->getRepository('ChrisKfzBuchungBundle:Rent');

$qb = $repo->createQueryBuilder('s');
$qb->from('ChrisKfzBuchungBundle:Auto', 'a')
    ->where('s.mieteStart >= :date_from')
    ->andWhere('s.mieteEnde <= :date_to')
    ->setParameter('date_from', $date_from)
    ->setParameter('date_to', $date_to);

How do I join one ore more tables with queryBuilder?

i tried this post already, it doesnt seem to be supported in the actual symfony 2 version — Mikado Joe
– Mikado Joe, Commented Dec 15, 2014 at 18:49

Markus Kottländer · Accepted Answer · 2014-12-15 18:51:58Z

2

There are methods for that and also for me it just worked with a configured relation between the two entites. Here are two working examples:

left join:

$query = $repo->createQueryBuilder('s')
    ->leftJoin(ChrisKfzBuchungBundle:Auto', 'a', 'WITH', 's.id = a.yourJoinCOlumn')
    ...

inner join:

$query = $repo->createQueryBuilder('s')
    ->select('s, a')
    ->innerJoin('s.yourJoinColumn', 'a')
    ...

answered Dec 15, 2014 at 18:51

Markus Kottländer

8,2844 gold badges42 silver badges61 bronze badges

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

1 Comment

Mikado Joe Over a year ago

[Semantical Error] line 0, col 90 near 's a WHERE s.mieteStart': Error: Class 's' is not defined. please post the complete code. where in your left join is a definded?

Collectives™ on Stack Overflow

Using an Inner Join with QueryBuilder on Symfony2

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related