JOIN error with Symfony

Question

Navigation

#1 by (0 votes)

0

I have a relationship between 2 Orders and Users tables from the field user_id and id respectively.

I make this query:

$dql="SELECT u, o
      FROM BackendBundle:Orders o
      JOIN o.users u";
$query=$em->createQuery($dql);

And this is the error that shows me:

[Semantical Error] line 0, col 68 near 'u': Error: Class BackendBundle \ Entity \ Orders has no association named users

And I do not know how I can correct this error.

join symfony3 symfony dql

asked by juanitourquiza 02.08.2017 в 05:30

source

1 answer

does anyone know how to define the html2pdf favicon? Create user Administrator using a view

score 0 · Answer 1

Performing more tests I found the solution. It was just to put user and not plural users . The query looks like this:

$dql="SELECT u, o
      FROM BackendBundle:Orders o
      JOIN o.user u";
$query=$em->createQuery($dql);