public function findRecent(Tool $tool) { $this->getEntityManager()->createQueryBuilder(); $qb = $this->createQueryBuilder('e'); $qb->join('e.eventIdentifier', 'ei'); $qb->where($qb->expr()->andX('e.type = :toolIdentifier', 'ei.project = :project')); $qb->setParameter('toolIdentifier', $tool->getIdentifier()); $qb->setParameter('project', $tool->getProject()); $qb->orderBy('e.created', 'DESC'); $results = $qb->getQuery()->getResult(); if (count($results) == 0) { return null; } else { return $results[0]; } }