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