public function getAllByArticleNumber($articleNumber, $fetchReplies = true) { $qb = $this->createQueryBuilder('ec'); $qb->select('ec', 'u')->join('ec.user', 'u')->where('ec.articleNumber = :articleNumber')->andWhere('ec.is_active = :is_active')->andWhere('ec.resolved = false')->setParameters(array('articleNumber' => $articleNumber, 'is_active' => true)); if (!$fetchReplies) { $qb->andWhere($qb->expr()->isNull('ec.parentId')); } return $qb->getQuery(); }