Index: openacs-4/packages/ecommerce/www/admin/problems/index-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ecommerce/www/admin/problems/index-oracle.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/ecommerce/www/admin/problems/index-oracle.xql	10 Jul 2001 20:33:53 -0000	1.1
+++ openacs-4/packages/ecommerce/www/admin/problems/index-oracle.xql	26 May 2002 04:36:50 -0000	1.2
@@ -1,21 +1,22 @@
 <?xml version="1.0"?>
 
 <queryset>
-   <rdbms><type>oracle</type><version>8.1.6</version></rdbms>
+  <rdbms><type>oracle</type><version>8.1.6</version></rdbms>
 
-<fullquery name="problems_select">      
-      <querytext>
-      
- select 
-      l.*, 
-      u.first_names || ' ' || u.last_name as user_name
- from ec_problems_log l, 
-      cc_users u
- where l.resolved_by = u.user_id(+)
-      $sql_clause
- order by problem_date asc
-      </querytext>
-</fullquery>
+  <partialquery name="include_resolved_date">
+    <querytext>
+      and resolved_date is null
+    </querytext>
+  </partialquery>
 
- 
+  <fullquery name="problems_select">      
+    <querytext>
+      select l.*, u.first_names || ' ' || u.last_name as user_name
+      from ec_problems_log l
+      where l.resolved_by = u.user_id(+)
+      $sql_clause
+      order by problem_date asc
+    </querytext>
+  </fullquery>
+  
 </queryset>