* reports for a dataset * @param $datasetId * @return array * @throws Exception */
($datasetId)
| 420 | * @throws Exception |
| 421 | */ |
| 422 | public function reportsForDataset($datasetId) |
| 423 | { |
| 424 | $sql = $this->db->getQueryBuilder(); |
| 425 | $sql->from(self::TABLE_NAME) |
| 426 | ->select('id') |
| 427 | ->addSelect('name') |
| 428 | ->addSelect('user_id') |
| 429 | ->where($sql->expr()->eq('dataset', $sql->createNamedParameter($datasetId))); |
| 430 | $statement = $sql->executeQuery(); |
| 431 | $result = $statement->fetchAll(); |
| 432 | $statement->closeCursor(); |
| 433 | return $result; |
| 434 | } |
| 435 | |
| 436 | /** |
| 437 | * increase version for all reports of a dataset |