/** * @param Build $build * * @return null|App\Model\Build */ public function findPreviousDemoBuild(Build $build) { $query = $this->createQueryBuilder('b')->select()->where('b.host = ?1')->andWhere('b.status IN(?2)')->setParameters([1 => $build->getHost(), 2 => [Build::STATUS_RUNNING, Build::STATUS_OBSOLETE]])->setMaxResults(1)->orderBy('b.createdAt', 'DESC')->getQuery(); try { return $query->getSingleResult(); } catch (NoResultException $e) { return null; } }