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 -N -r1.4 -r1.5 --- openacs-4/packages/bug-tracker/tcl/bug-tracker-procs-postgresql.xql 24 Feb 2005 13:33:04 -0000 1.4 +++ openacs-4/packages/bug-tracker/tcl/bug-tracker-procs-postgresql.xql 28 Feb 2005 09:27:06 -0000 1.5 @@ -187,22 +187,22 @@ - + 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 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 + 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