Index: openacs-4/packages/bug-tracker/tcl/bug-procs.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/bug-tracker/tcl/bug-procs.xql,v diff -u -r1.4.4.2 -r1.4.4.3 --- openacs-4/packages/bug-tracker/tcl/bug-procs.xql 23 Jan 2005 00:12:54 -0000 1.4.4.2 +++ openacs-4/packages/bug-tracker/tcl/bug-procs.xql 27 Jan 2005 02:29:32 -0000 1.4.4.3 @@ -89,43 +89,6 @@ and p.project_id = b.project_id - - - - select st.pretty_name, - st.state_id, - count(b.bug_id) - from workflow_fsm_states st, - bt_bugs b, - workflow_cases cas, - workflow_case_fsm cfsm - where st.workflow_id = :workflow_id - and b.project_id = :package_id - and cas.workflow_id = :workflow_id - and cas.object_id = b.bug_id - and cfsm.case_id = cas.case_id - and st.state_id = cfsm.current_state - group by st.state_id, st.pretty_name, st.sort_order - order by st.sort_order - - - - - - - - select c.component_name, - c.component_id, - count(b.bug_id) as num_bugs - from bt_bugs b, - bt_components c - where b.project_id = :package_id - and c.component_id = b.component_id - group by c.component_name, c.component_id - order by c.component_name - - -