From 62d22c66261e824b03236cca9e21528cc436f4fc Mon Sep 17 00:00:00 2001
From: Paul Holden <paulh@moodle.com>
Date: Wed, 31 Aug 2022 09:16:06 +0100
Subject: [PATCH] MDL-75191 task: cross DB support for task output filter.

Specifically avoids Oracle exception ORA-00932.
---
 admin/classes/local/entities/task_log.php | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

diff --git a/admin/classes/local/entities/task_log.php b/admin/classes/local/entities/task_log.php
index e454eece5ab..28d34c2a7f0 100644
--- a/admin/classes/local/entities/task_log.php
+++ b/admin/classes/local/entities/task_log.php
@@ -283,7 +283,7 @@ class task_log extends base {
      * @return filter[]
      */
     protected function get_all_filters(): array {
-        $filters = [];
+        global $DB;
 
         $tablealias = $this->get_table_alias('task_log');
 
@@ -342,7 +342,7 @@ class task_log extends base {
             'output',
             new lang_string('task_logoutput', 'admin'),
             $this->get_entity_name(),
-            "{$tablealias}.output"
+            $DB->sql_cast_to_char("{$tablealias}.output")
         ))
             ->add_joins($this->get_joins());
 
-- 
2.43.0