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 @@
-
-
-
- oracle8.1.6
-
-
-
- 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
-
-
-
-
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 @@
-
-
-
- postgresql7.1
-
-
-
- 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
-
-
-
-
-
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
-
+
+
+
+ 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
+
+
+