public function getCountBy($field, $value) { $qb = $this->createQueryBuilder("a"); $qb->select("count(a.id)")->where($qb->expr()->eq("a.{$field}", ':value'))->setParameter("value", $value); return $qb->getQuery()->getSingleScalarResult(); }