I have a simple ER diagram with entities and properties 1:n. Retrieving an
entity by its uuid will also obtain all it's properties:
$dql = 'SELECT a, p
FROM Volkszaehler\Model\Entity a
LEFT JOIN a.properties p
WHERE a.uuid = :uuid';
$q = $em->createQuery($dql)
->setParameter('uuid', $uuid);
$entity = $q->getSingleResult();
var_dump($entity->getProperties()); // all properties
Now, for some cases I'm identifying the entity by name (and make sure it's
of public type), obtain the uuid and then pass it through the above query:
$dql = 'SELECT e, p
FROM Volkszaehler\Model\Entity e
LEFT JOIN e.properties p
JOIN e.properties public
WHERE p.key = :key
AND p.value = :name
AND public.key = :key2
AND public.value = 1';
$q = $this->em->createQuery($dql)
->setParameter('key', 'title')
->setParameter('name', $name)
->setParameter('key2', 'public');
$entity = $q->getSingleResult();
Now, calling the first query with the UUID, only a single property is
returned but not all of them as expected:
var_dump($entity->getProperties()); // only 'title' property is shown
SQL trace shows that the exact same queries are executed, only in the 2nd
case the properties apparently are swallowed by the ORM.
Any idea what's wrong here?
Thanks,
Andreas
--
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 https://groups.google.com/group/doctrine-user.
For more options, visit https://groups.google.com/d/optout.
