diff options
| author | Daniel Kesselberg <mail@danielkesselberg.de> | 2021-08-16 15:28:09 +0300 |
|---|---|---|
| committer | backportbot[bot] <backportbot[bot]@users.noreply.github.com> | 2021-08-20 16:40:43 +0300 |
| commit | bd30d97857fab2ee8a7366c046b74f594c8c5451 (patch) | |
| tree | 09fd2a8f3f7dd3f53b77d9d5aa08e2e862445ddb /apps | |
| parent | 8be50456e5938f8b7c478adafc0f06c674cff9f3 (diff) | |
Set alias for result of cast column function
On OCI an expression like to_char(events) end up as $row['to_char(events)'] in the query result.
Signed-off-by: Daniel Kesselberg <mail@danielkesselberg.de>
Diffstat (limited to 'apps')
| -rw-r--r-- | apps/workflowengine/lib/Manager.php | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/apps/workflowengine/lib/Manager.php b/apps/workflowengine/lib/Manager.php index d0eee80ca37..178bc87365b 100644 --- a/apps/workflowengine/lib/Manager.php +++ b/apps/workflowengine/lib/Manager.php @@ -155,7 +155,8 @@ class Manager implements IManager { public function getAllConfiguredEvents() { $query = $this->connection->getQueryBuilder(); - $query->select('class', 'entity', $query->expr()->castColumn('events', IQueryBuilder::PARAM_STR)) + $query->select('class', 'entity') + ->selectAlias($query->expr()->castColumn('events', IQueryBuilder::PARAM_STR), 'events') ->from('flow_operations') ->where($query->expr()->neq('events', $query->createNamedParameter('[]'), IQueryBuilder::PARAM_STR)) ->groupBy('class', 'entity', $query->expr()->castColumn('events', IQueryBuilder::PARAM_STR)); |