Hi,
I have DQL query:
$query = $qb->select('ta', 'at')
->from('EveStatic\Entity\DgmTypeAttribute', 'ta')
->innerJoin('ta.attributeID', 'at')
->where('ta.typeID = :typeID')
->setParameter('typeID', $this->typeID)
->getQuery();
getSQL() returns:
SELECT d0_.typeID AS typeID0, d0_.valueInt AS valueInt1, d0_.valueFloat AS
valueFloat2, d1_.attributeID AS attributeID3, d1_.attributeName AS
attributeName4, d1_.description AS description5, d1_.iconID AS iconID6,
d1_.defaultValue AS defaultValue7, d1_.published AS published8, d1_.displayName
AS displayName9, d1_.unitID AS unitID10, d1_.stackable AS stackable11,
d1_.highIsGood AS highIsGood12, d0_.attributeID AS attributeID13,
d1_.categoryID AS categoryID14 FROM dgmTypeAttributes d0_ INNER JOIN
dgmAttributeTypes d1_ ON d0_.attributeID = d1_.attributeID WHERE d0_.typeID = ?
Directly at mysql it returns 8 rows, but getResult() or getArrayResult()
returns only first row with relations loaded. It should return 8 unique rows
with relations loaded I think.
Can anyone help me please and tell me, what I am doing wrong?
Thanks,
Miroslav Misek
--
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/groups/opt_out.
