Index: openacs-4/packages/bug-tracker/tcl/bug-procs-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/bug-tracker/tcl/bug-procs-oracle.xql,v
diff -u -r1.4.2.8 -r1.4.2.9
--- openacs-4/packages/bug-tracker/tcl/bug-procs-oracle.xql 23 Jan 2005 00:21:37 -0000 1.4.2.8
+++ openacs-4/packages/bug-tracker/tcl/bug-procs-oracle.xql 27 Jan 2005 02:29:32 -0000 1.4.2.9
@@ -75,62 +75,7 @@
end;
-
-
-
- select kw.heading,
- km.keyword_id,
- count(b.bug_id)
- from cr_keywords kw,
- cr_item_keyword_map km,
- bt_bugs b
- where kw.parent_id = :parent_id
- and km.keyword_id = kw.keyword_id
- and b.bug_id (+) = km.item_id
- and b.project_id = :package_id
- group by kw.heading, km.keyword_id
- order by kw.heading
-
-
-
-
-
-
-
- select v.version_name,
- b.fix_for_version,
- count(b.bug_id) as num_bugs
- from bt_bugs b,
- bt_versions v
- where b.project_id = :package_id
- and v.version_id (+) = b.fix_for_version
- group by b.fix_for_version, v.anticipated_freeze_date, v.version_name
- order by v.anticipated_freeze_date, v.version_name
-
-
-
-
-
-
- select p.first_names || ' ' || p.last_name as name,
- crum.user_id,
- count(b.bug_id) as num_bugs
- from bt_bugs b,
- workflow_case_assigned_actions aa,
- workflow_case_role_user_map crum,
- persons p
- where b.project_id = :package_id
- and aa.workflow_id = :workflow_id
- and aa.action_id = :action_id
- and aa.object_id = b.bug_id
- and crum.case_id (+) = aa.case_id
- and crum.role_id (+) = aa.role_id
- and p.person_id (+) = crum.user_id
- group by p.first_names, p.last_name, crum.user_id
-
-
-
content_keyword.is_assigned(b.bug_id, :f_category_$parent_id, 'none') = 't'