/** * @param ProjectEntity $project * @param Access $access * * @return ResultEntity[] */ public function findResultByProjectAndAccess(ProjectEntity $project, Access $access) { $qb = $this->_em->createQueryBuilder(); $qb->select('r'); $qb->from("Project\\Entity\\Result\\Result", 'r'); $qb->join('r.type', 't'); $qb->join('t.access', 'a'); $qb->where('r.project = ?1'); $qb->andWhere($qb->expr()->in('a.id', [$access->getId()])); $qb->setParameter(1, $project); return $qb->getQuery()->getResult(); }