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.3.4.1 -r1.3.4.2
--- openacs-4/packages/bug-tracker/tcl/bug-tracker-procs-postgresql.xql 27 Jan 2005 02:29:32 -0000 1.3.4.1
+++ openacs-4/packages/bug-tracker/tcl/bug-tracker-procs-postgresql.xql 19 Feb 2005 18:24:09 -0000 1.3.4.2
@@ -186,4 +186,24 @@
+
+
+
+ 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) w
+ here p.package_id = :project_id
+
+
+