diff options
| author | Daniel Kesselberg <mail@danielkesselberg.de> | 2021-08-16 14:28:09 +0200 |
|---|---|---|
| committer | Daniel Kesselberg <mail@danielkesselberg.de> | 2021-08-16 14:38:19 +0200 |
| commit | 7492b3c24f91e5896b382bcb8196bfba28deda78 (patch) | |
| tree | f1911a28fcd8c976ee473cd4daa6e45d2f13c656 /apps | |
| parent | 9585c4f2561efd04a85b72b1100bd3593129b00c (diff) | |
| download | nextcloud-server-7492b3c24f91e5896b382bcb8196bfba28deda78.tar.gz nextcloud-server-7492b3c24f91e5896b382bcb8196bfba28deda78.zip | |
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)); |