Index: openacs-4/packages/bug-tracker/www/index-oracle.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/bug-tracker/www/Attic/index-oracle.xql,v diff -u -r1.2 -r1.3 --- openacs-4/packages/bug-tracker/www/index-oracle.xql 28 Aug 2003 09:45:29 -0000 1.2 +++ openacs-4/packages/bug-tracker/www/index-oracle.xql 22 Sep 2003 19:30:36 -0000 1.3 @@ -152,6 +152,7 @@ from bt_components com where com.project_id = :package_id) c where c.component_id = b.component_id + and b.project_id = :package_id and cas.object_id = b.bug_id and cas.case_id = cfsm.case_id and cfsm.current_state = :initial_state_id Index: openacs-4/packages/bug-tracker/www/index-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/bug-tracker/www/Attic/index-postgresql.xql,v diff -u -r1.2 -r1.3 --- openacs-4/packages/bug-tracker/www/index-postgresql.xql 28 Aug 2003 09:45:29 -0000 1.2 +++ openacs-4/packages/bug-tracker/www/index-postgresql.xql 22 Sep 2003 19:30:36 -0000 1.3 @@ -146,6 +146,7 @@ from bt_components com where com.project_id = :package_id) c where c.component_id = b.component_id + and b.project_id = :package_id and cas.object_id = b.bug_id and cas.case_id = cfsm.case_id and cfsm.current_state = :initial_state_id Index: openacs-4/packages/bug-tracker/www/index.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/bug-tracker/www/Attic/index.xql,v diff -u -r1.1 -r1.2 --- openacs-4/packages/bug-tracker/www/index.xql 5 Mar 2003 17:41:04 -0000 1.1 +++ openacs-4/packages/bug-tracker/www/index.xql 22 Sep 2003 19:30:36 -0000 1.2 @@ -51,6 +51,7 @@ workflow_case_fsm cfsm where cas.object_id = bt_bugs.bug_id and cas.case_id = cfsm.case_id + and bt_bugs.project_id = :package_id and cfsm.current_state = '4' and not exists (select 1 from workflow_actions a,