Fisheye: Tag 1.3 refers to a dead (removed) revision in file `openacs-4/packages/bug-tracker/www/admin/component-ae-oracle.xql'.
Fisheye: No comparison available. Pass `N' to diff?
Fisheye: Tag 1.3 refers to a dead (removed) revision in file `openacs-4/packages/bug-tracker/www/admin/component-ae-postgresql.xql'.
Fisheye: No comparison available. Pass `N' to diff?
Index: openacs-4/packages/bug-tracker/www/admin/component-ae.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/bug-tracker/www/admin/component-ae.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/bug-tracker/www/admin/component-ae.xql 5 Mar 2003 17:41:17 -0000 1.1
+++ openacs-4/packages/bug-tracker/www/admin/component-ae.xql 23 Nov 2017 15:30:24 -0000 1.2
@@ -26,5 +26,16 @@
</querytext>
</fullquery>
+<fullquery name="user_search">
+ <querytext>
+ select distinct u.first_names || ' ' || u.last_name || ' (' || u.email || ')' as name, u.user_id
+ from cc_users u
+ where upper(coalesce(u.first_names || ' ', '') ||
+ coalesce(u.last_name || ' ', '') ||
+ u.email || ' ' ||
+ coalesce(u.screen_name, '')) like upper('%'||:value||'%')
+ order by name
+ </querytext>
+</fullquery>
</queryset>
Fisheye: Tag 1.3 refers to a dead (removed) revision in file `openacs-4/packages/bug-tracker/www/admin/project-edit-oracle.xql'.
Fisheye: No comparison available. Pass `N' to diff?
Fisheye: Tag 1.2 refers to a dead (removed) revision in file `openacs-4/packages/bug-tracker/www/admin/project-edit-postgresql.xql'.
Fisheye: No comparison available. Pass `N' to diff?
Index: openacs-4/packages/bug-tracker/www/admin/project-edit.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/bug-tracker/www/admin/project-edit.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/bug-tracker/www/admin/project-edit.xql 5 Mar 2003 17:41:17 -0000 1.1
+++ openacs-4/packages/bug-tracker/www/admin/project-edit.xql 23 Nov 2017 15:32:17 -0000 1.2
@@ -26,5 +26,16 @@
</querytext>
</fullquery>
+<fullquery name="project_search">
+ <querytext>
+ select distinct u.first_names || ' ' || u.last_name || ' (' || u.email || ')' as name, u.user_id
+ from cc_users u
+ where upper(coalesce(u.first_names || ' ', '') ||
+ coalesce(u.last_name || ' ', '') ||
+ u.email || ' ' ||
+ coalesce(u.screen_name, '')) like upper('%'||:value||'%')
+ order by name
+ </querytext>
+</fullquery>
</queryset>
Fisheye: Tag 1.4 refers to a dead (removed) revision in file `openacs-4/packages/bug-tracker/www/admin/version-ae-oracle.xql'.
Fisheye: No comparison available. Pass `N' to diff?
Fisheye: Tag 1.3 refers to a dead (removed) revision in file `openacs-4/packages/bug-tracker/www/admin/version-ae-postgresql.xql'.
Fisheye: No comparison available. Pass `N' to diff?
Index: openacs-4/packages/bug-tracker/www/admin/version-ae.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/bug-tracker/www/admin/version-ae.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/bug-tracker/www/admin/version-ae.xql 5 Mar 2003 17:41:17 -0000 1.1
+++ openacs-4/packages/bug-tracker/www/admin/version-ae.xql 23 Nov 2017 15:35:13 -0000 1.2
@@ -78,5 +78,16 @@
</querytext>
</fullquery>
+<fullquery name="user_search">
+ <querytext>
+ select distinct u.first_names || ' ' || u.last_name || ' (' || u.email || ')' as name, u.user_id
+ from cc_users u
+ where upper(coalesce(u.first_names || ' ', '') ||
+ coalesce(u.last_name || ' ', '') ||
+ u.email || ' ' ||
+ coalesce(u.screen_name, '')) like upper('%'||:value||'%')
+ order by name
+ </querytext>
+</fullquery>
</queryset>
Fisheye: Tag 1.2 refers to a dead (removed) revision in file `openacs-4/packages/bug-tracker/www/admin/version-release-oracle.xql'.
Fisheye: No comparison available. Pass `N' to diff?
Fisheye: Tag 1.2 refers to a dead (removed) revision in file `openacs-4/packages/bug-tracker/www/admin/version-release-postgresql.xql'.
Fisheye: No comparison available. Pass `N' to diff?
Index: openacs-4/packages/bug-tracker/www/admin/version-release.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/bug-tracker/www/admin/version-release.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/bug-tracker/www/admin/version-release.xql 5 Mar 2003 17:41:17 -0000 1.1
+++ openacs-4/packages/bug-tracker/www/admin/version-release.xql 23 Nov 2017 15:38:30 -0000 1.2
@@ -1,15 +1,22 @@
<?xml version="1.0"?>
<queryset>
-<fullquery name="update_version">
- <querytext>
-
- update bt_versions
- set actual_release_date = $actual_release_date
- where version_id = :version_id
-
- </querytext>
-</fullquery>
+ <fullquery name="update_version">
+ <querytext>
+ update bt_versions
+ set actual_release_date = $actual_release_date
+ where version_id = :version_id
+ </querytext>
+ </fullquery>
-
+ <fullquery name="version_select">
+ <querytext>
+ select version_name,
+ to_char(anticipated_release_date, 'YYYY MM DD HH24 MI') as anticipated_release_date,
+ to_char(coalesce(actual_release_date, current_timestamp), 'YYYY MM DD HH24 MI') as actual_release_date
+ from bt_versions
+ where version_id = :version_id
+ </querytext>
+ </fullquery>
+
</queryset>