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