Index: openacs-4/packages/bug-tracker/tcl/bug-tracker-procs-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/bug-tracker/tcl/bug-tracker-procs-oracle.xql,v
diff -u -r1.4 -r1.5
--- openacs-4/packages/bug-tracker/tcl/bug-tracker-procs-oracle.xql 30 Sep 2003 12:10:04 -0000 1.4
+++ openacs-4/packages/bug-tracker/tcl/bug-tracker-procs-oracle.xql 24 Feb 2005 13:33:04 -0000 1.5
@@ -133,4 +133,76 @@
+
+
+ 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 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
+
+
+
+
+
+ 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, acs_objects o
+ where p.package_id = o.object_id
+ and p.package_id = :project_id
+
+
+
+