This is actually the expected result when having multiple selected entities in an arbitrary join DQL query.
Same result if you select various scalar fields and then the root of the selection in your DQL. Marco Pivetta http://twitter.com/Ocramius http://ocramius.github.com/ On 2 December 2014 at 11:55, Andrius Kulbis <[email protected]> wrote: > Hello, > > I have the following entity: > > /** > * @ORM\Table(name="Employee") > * > @ORM\Entity(repositoryClass="Project\BackendBundle\Entity\Repository\EmployeeRepository") > */ > class Employee > { > /** > * @var integer > * > * @ORM\Column(name="id", type="integer") > * @ORM\Id > * @ORM\GeneratedValue(strategy="IDENTITY") > */ > private $id; > > /** > * @ORM\ManyToOne(targetEntity="Division") > * @ORM\JoinColumn(name="division_id", referencedColumnName="id") > * @Expose > **/ > private $division; > > /** > * @ORM\ManyToOne(targetEntity="Position") > * @ORM\JoinColumn(name="position_id", referencedColumnName="id") > */ > private $position; > > ..... > } > > With my REST API, I want to make the filter called "fields", where I put > the comma separated list of entity fields, that I want to retrieve. Also I > would like to be able to put associated fields there. So the request looks > like this: > > /api/employee?fields=id,division > > I check these fields, if they exist in entity fields or association map. > > Every associated field is added to the query like this: > foreach ( $this->assoc as $key => $mapping ) { > $queryBuilder > ->addSelect(substr($key, 0, 1) . ' AS ' . $key) > ->leftJoin( > $mapping['targetEntity'], > substr($key, 0, 1), > \Doctrine\ORM\Query\Expr\Join::WITH, > substr($key, 0, 1) . ' = u.' . $key > ); > } > > > From the request above I get the following DQL: > > SELECT u.id, d AS division FROM Project\BackendBundle\Entity\Employee u LEFT > JOIN Project\BackendBundle\Entity\Division d WITH d = u.division > > > Everything is fine, I get the expected result (*var_dump()*) > > ): > > *array* *(size=1)* > 0 => > *array* *(size=2)* > 'division' => > *object*(*Project\BackendBundle\Entity\division*)[*645*] > *private* 'id' => int 20 > *private* 'name' => string 'division1' *(length=9)* > 'id' => int 890 > > > > Now if I add one more associated field to my requested fields: > /api/employee?fields=id,division,position > > I get the following DQL: > > SELECT u.id, d AS division, p AS position FROM > Project\BackendBundle\Entity\Employee u LEFT JOIN > Project\BackendBundle\Entity\Division d WITH d = u.division LEFT JOIN > Project\BackendBundle\Entity\Position p WITH p= u.position > > > The results now looks like this: > > *array* *(size=2)* > 0 => > *array* *(size=1)* > 'division' => > *object*(*Project\BackendBundle\Entity\Kategorija*)[*672*] > *private* 'id' => int 20 > *private* 'name' => string 'division1' *(length=9)* > 1 => > *array* *(size=2)* > 'position' => > *object*(*Project\BackendBundle\Entity\Position*)[*629*] > *private* 'id' => int 15 > *private* 'name' => string 'Manager' *(length=7)* > 'id' => int 890 > > > The problem is that now the result of one entity lies in two arrays > instead of one. > > The expected result was: > > *array* *(size=1)* > 0 => > *array* *(size=3)* > 'division' => > *object*(*Project\BackendBundle\Entity\Kategorija*)[*672*] > *private* 'id' => int 20 > *private* 'name' => string 'division1' *(length=9)* > 'position' => > *object*(*Project\BackendBundle\Entity\Position*)[*629*] > *private* 'id' => int 15 > *private* 'name' => string 'Manager' *(length=7)* > 'id' => int 890 > > > What I am missing or doing wrong? > > > -- > You received this message because you are subscribed to the Google Groups > "doctrine-user" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > Visit this group at http://groups.google.com/group/doctrine-user. > For more options, visit https://groups.google.com/d/optout. > -- You received this message because you are subscribed to the Google Groups "doctrine-user" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/doctrine-user. For more options, visit https://groups.google.com/d/optout.
