Index: openacs-4/packages/bug-tracker/www/patch-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/bug-tracker/www/Attic/patch-oracle.xql,v
diff -u -N
--- openacs-4/packages/bug-tracker/www/patch-oracle.xql	1 Dec 2005 13:06:10 -0000	1.3
+++ /dev/null	1 Jan 1970 00:00:00 -0000
@@ -1,38 +0,0 @@
-<?xml version="1.0"?>
-
-<queryset>
-   <rdbms><type>oracle</type><version>8.1.6</version></rdbms>
-
-<fullquery name="patch">
-  <querytext>
-     select bt_patches.patch_id,
-            bt_patches.patch_number,
-            bt_patches.project_id,
-            bt_patches.component_id,
-            bt_patches.summary,
-            bt_patches.content,
-            bt_patches.generated_from_version,
-            bt_patches.apply_to_version,
-            bt_patches.applied_to_version,
-            bt_patches.status,
-            bt_components.component_name,
-            acs_objects.creation_user as submitter_user_id,
-            submitter.first_names as submitter_first_names,
-            submitter.last_name as submitter_last_name,
-            submitter.email as submitter_email,
-            acs_objects.creation_date,
-            to_char(acs_objects.creation_date, 'YYYY-MM-DD HH24:MI:SS') as creation_date_pretty,
-            to_char(sysdate, 'YYYY-MM-DD HH24:MI:SS') as now_pretty
-     from bt_patches,
-          acs_objects,
-	  acs_users_all submitter,
-          bt_components
-     where bt_patches.patch_number = :patch_number
-       and bt_patches.project_id = :package_id
-       and bt_patches.patch_id = acs_objects.object_id
-       and bt_patches.component_id = bt_components.component_id
-       and submitter.user_id = acs_objects.creation_user
-  </querytext>
-</fullquery>
-
-</queryset>
Index: openacs-4/packages/bug-tracker/www/patch-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/bug-tracker/www/Attic/patch-postgresql.xql,v
diff -u -N
--- openacs-4/packages/bug-tracker/www/patch-postgresql.xql	1 Dec 2005 13:06:10 -0000	1.3
+++ /dev/null	1 Jan 1970 00:00:00 -0000
@@ -1,39 +0,0 @@
-<?xml version="1.0"?>
-
-<queryset>
-   <rdbms><type>postgresql</type><version>7.1</version></rdbms>
-
-<fullquery name="patch">
-  <querytext>
-     select bt_patches.patch_id,
-            bt_patches.patch_number,
-            bt_patches.project_id,
-            bt_patches.component_id,
-            bt_patches.summary,
-            bt_patches.content,
-            bt_patches.generated_from_version,
-            bt_patches.apply_to_version,
-            bt_patches.applied_to_version,
-            bt_patches.status,
-            bt_components.component_name,
-            acs_objects.creation_user as submitter_user_id,
-            submitter.first_names as submitter_first_names,
-            submitter.last_name as submitter_last_name,
-            submitter.email as submitter_email,
-            acs_objects.creation_date,
-            to_char(acs_objects.creation_date, 'YYYY-MM-DD HH24:MI:SS') as creation_date_pretty,
-            to_char(now(), 'YYYY-MM-DD HH24:MI:SS') as now_pretty
-     from bt_patches,
-          acs_objects,
-          acs_users_all submitter,
-          bt_components
-     where bt_patches.patch_number = :patch_number
-       and bt_patches.project_id = :package_id
-       and bt_patches.patch_id = acs_objects.object_id
-       and bt_patches.component_id = bt_components.component_id
-       and submitter.user_id = acs_objects.creation_user
-  </querytext>
-</fullquery>
-
-
-</queryset>
Index: openacs-4/packages/bug-tracker/www/patch.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/bug-tracker/www/patch.xql,v
diff -u -N -r1.4 -r1.5
--- openacs-4/packages/bug-tracker/www/patch.xql	1 Dec 2005 13:06:10 -0000	1.4
+++ openacs-4/packages/bug-tracker/www/patch.xql	23 Nov 2017 15:42:15 -0000	1.5
@@ -62,5 +62,37 @@
           where action_id=:action_id and case_id=:case_id
       </querytext>
 </fullquery>
-  
+
+<fullquery name="patch">
+  <querytext>
+     select bt_patches.patch_id,
+            bt_patches.patch_number,
+            bt_patches.project_id,
+            bt_patches.component_id,
+            bt_patches.summary,
+            bt_patches.content,
+            bt_patches.generated_from_version,
+            bt_patches.apply_to_version,
+            bt_patches.applied_to_version,
+            bt_patches.status,
+            bt_components.component_name,
+            acs_objects.creation_user as submitter_user_id,
+            submitter.first_names as submitter_first_names,
+            submitter.last_name as submitter_last_name,
+            submitter.email as submitter_email,
+            acs_objects.creation_date,
+            to_char(acs_objects.creation_date, 'YYYY-MM-DD HH24:MI:SS') as creation_date_pretty,
+            to_char(current_timestamp, 'YYYY-MM-DD HH24:MI:SS') as now_pretty
+     from bt_patches,
+          acs_objects,
+          acs_users_all submitter,
+          bt_components
+     where bt_patches.patch_number = :patch_number
+       and bt_patches.project_id = :package_id
+       and bt_patches.patch_id = acs_objects.object_id
+       and bt_patches.component_id = bt_components.component_id
+       and submitter.user_id = acs_objects.creation_user
+  </querytext>
+</fullquery>
+
 </queryset>