commit 2b3809f440edb9bd365fbb82149668a4bf027b48 parent 4828891105640c4cdfdc298e0e58432c37034f1c Author: Felicitus <felicitus@felicitus.org> Date: Sun, 31 Mar 2013 08:58:03 +0200 Fixed Issue #268 Diffstat:
M | src/backend/PartKeepr/Part/PartManager.php | | | 4 | +++- |
1 file changed, 3 insertions(+), 1 deletion(-)
diff --git a/src/backend/PartKeepr/Part/PartManager.php b/src/backend/PartKeepr/Part/PartManager.php @@ -167,7 +167,9 @@ class PartManager extends AbstractManager { return array(); } - $dql = "SELECT p.id, COUNT(pa) AS cnt FROM PartKeepr\Part\PartAttachment pa JOIN pa.part p WHERE pa.part IN (:partids) GROUP BY pa.part"; + $dql = "SELECT p.id, COUNT(pa) AS cnt FROM PartKeepr\Part\PartAttachment pa JOIN pa.part p WHERE pa.part IN "; + $dql .= "(:partids) GROUP BY pa.part, p.id"; + $partAttachmentQuery = PartKeepr::getEM()->createQuery($dql); $partAttachmentQuery->setParameter("partids", $partIds);