Index: openacs-4/packages/bug-tracker/tcl/bug-tracker-procs-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/bug-tracker/tcl/bug-tracker-procs-oracle.xql,v
diff -u -r1.8 -r1.9
--- openacs-4/packages/bug-tracker/tcl/bug-tracker-procs-oracle.xql 23 Nov 2017 15:10:37 -0000 1.8
+++ openacs-4/packages/bug-tracker/tcl/bug-tracker-procs-oracle.xql 3 Sep 2019 11:57:48 -0000 1.9
@@ -11,12 +11,6 @@
-
-
- select acs_object.name(party_id) from parties where party_id = :filter_assignee
-
-
-
content_keyword.is_assigned(b.bug_id, $keyword_id, 'none') = 't'
@@ -39,15 +33,4 @@
-
-
- select acs_object.name(p.party_id) || ' (' || p.email || ')' as label,
- party_id from parties p
- where party_id in (select distinct(party_id) from workflow_case_role_party_map,
- workflow_cases
- where workflow_case_role_party_map.case_id = workflow_cases.case_id
- and workflow_cases.workflow_id = :workflow_id)
-
-
-
Index: openacs-4/packages/bug-tracker/tcl/bug-tracker-procs-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/bug-tracker/tcl/bug-tracker-procs-postgresql.xql,v
diff -u -r1.8 -r1.9
--- openacs-4/packages/bug-tracker/tcl/bug-tracker-procs-postgresql.xql 23 Nov 2017 15:10:37 -0000 1.8
+++ openacs-4/packages/bug-tracker/tcl/bug-tracker-procs-postgresql.xql 3 Sep 2019 11:57:48 -0000 1.9
@@ -9,12 +9,6 @@
-
-
- select acs_object__name(party_id) from parties where party_id = :filter_assignee
-
-
-
content_keyword__is_assigned(b.bug_id, $keyword_id, 'none')
@@ -48,15 +42,4 @@
-
-
- select acs_object__name(p.party_id) || ' (' || p.email || ')' as label,
- party_id from parties p
- where party_id in (select distinct(party_id) from workflow_case_role_party_map,
- workflow_cases
- where workflow_case_role_party_map.case_id = workflow_cases.case_id
- and workflow_cases.workflow_id = :workflow_id)
-
-
-
Index: openacs-4/packages/bug-tracker/tcl/bug-tracker-procs.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/bug-tracker/tcl/bug-tracker-procs.xql,v
diff -u -r1.11 -r1.12
--- openacs-4/packages/bug-tracker/tcl/bug-tracker-procs.xql 23 Nov 2017 15:26:00 -0000 1.11
+++ openacs-4/packages/bug-tracker/tcl/bug-tracker-procs.xql 3 Sep 2019 11:57:48 -0000 1.12
@@ -1,6 +1,23 @@
+
+
+ select acs_object.name(party_id) from parties where party_id = :filter_assignee
+
+
+
+
+
+ select acs_object.name(p.party_id) || ' (' || p.email || ')' as label,
+ party_id from parties p
+ where party_id in (select distinct(party_id) from workflow_case_role_party_map,
+ workflow_cases
+ where workflow_case_role_party_map.case_id = workflow_cases.case_id
+ and workflow_cases.workflow_id = :workflow_id)
+
+
+
select p.instance_name, o.creation_user, o.creation_ip from apm_packages p join acs_objects o on (p.package_id = o.object_id) where p.package_id = :project_id