public function getArticles($published = null) { $articleRepository = $this->em->getRepository('Newscoop\\Entity\\Article'); if ($published) { return $articleRepository->createQueryBuilder('a')->select('COUNT(a)')->where('a.workflowStatus = \'Y\'')->getQuery()->getSingleScalarResult(); } else { return $articleRepository->createQueryBuilder('a')->select('COUNT(a)')->getQuery()->getSingleScalarResult(); } }