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 @@ + + + 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 + + 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 @@ + + + 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 + + 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 @@ + + + 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 + + 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 @@ - - - - update bt_versions - set actual_release_date = $actual_release_date - where version_id = :version_id - - - + + + update bt_versions + set actual_release_date = $actual_release_date + where version_id = :version_id + + - + + + 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 + + +