Method getThresholdsByReport

lib/Db/ThresholdMapper.php:66–85

* @throws Exception */

($reportId)

     * @throws Exception
     */
    public function getThresholdsByReport($reportId)
    {
        $sql = $this->db->getQueryBuilder();
        $sql->from(self::TABLE_NAME)
            ->select('id')
            ->addSelect('dimension')
            ->addSelect('coloring')
            ->selectAlias('target', 'value')
            ->addSelect('option')
            ->addSelect('severity')
            ->addSelect('user_id')
            ->addSelect('sequence')
            ->where($sql->expr()->eq('report', $sql->createNamedParameter($reportId)))
            ->andWhere($sql->expr()->eq('user_id', $sql->createNamedParameter($this->userId)))
            ->orderBy('sequence', 'ASC');
        $statement = $sql->executeQuery();
        $result = $statement->fetchAll();
        $statement->closeCursor();
        return $result;
    }

	public function getReportByThreshold($id)
	{