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 @@
     </querytext>
   </fullquery>
 
+  <fullquery name="bug_tracker::category_get_filter_data_not_cached.select">
+    <querytext>
+        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
+    </querytext>
+  </fullquery>
+
+  <fullquery name="bug_tracker::version_get_filter_data_not_cached.select">
+    <querytext>
+        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
+    </querytext>
+  </fullquery>
+
+  <fullquery name="bug_tracker::assignee_get_filter_data_not_cached.select">
+    <querytext>
+      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
+    </querytext>
+  </fullquery>
+
+   <fullquery name="bug_tracker::assignee_get_options.assignees">      
+     <querytext>
+       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)
+     </querytext>
+    </fullquery>
+
+
+   <fullquery name="bug_tracker::project_new.instance_info">      
+     <querytext>
+	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      
+     </querytext>
+   </fullquery>
+
+
 </queryset>