* @throws Exception */
($reportId)
| 106 | * @throws Exception |
| 107 | */ |
| 108 | public function getSevOneThresholdsByReport($reportId) |
| 109 | { |
| 110 | $sql = $this->db->getQueryBuilder(); |
| 111 | $sql->from(self::TABLE_NAME) |
| 112 | ->select('*') |
| 113 | ->where($sql->expr()->eq('report', $sql->createNamedParameter($reportId))) |
| 114 | ->andWhere($sql->expr()->eq('severity', $sql->createNamedParameter('1'))) |
| 115 | ->orderBy('sequence', 'ASC'); |
| 116 | $statement = $sql->executeQuery(); |
| 117 | $result = $statement->fetchAll(); |
| 118 | $statement->closeCursor(); |
| 119 | return $result; |
| 120 | } |
| 121 | |
| 122 | /** |
| 123 | * @throws Exception |