Index: openacs-4/packages/ecommerce/tcl/ecommerce-customer-service-procs-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ecommerce/tcl/ecommerce-customer-service-procs-postgresql.xql,v
diff -u -r1.3 -r1.4
--- openacs-4/packages/ecommerce/tcl/ecommerce-customer-service-procs-postgresql.xql	26 May 2002 04:36:49 -0000	1.3
+++ openacs-4/packages/ecommerce/tcl/ecommerce-customer-service-procs-postgresql.xql	13 Jan 2005 13:57:55 -0000	1.4
@@ -29,5 +29,25 @@
       (:issue_id, :user_identification_id, :order_id, current_timestamp, current_timestamp, :customer_service_rep, :gift_certificate_id)
     </querytext>
   </fullquery>
+
+  <fullquery name="user_customer_service_issue">
+    <querytext>
+      select i.issue_id, i.open_date, i.close_date, m.issue_type
+      from ec_user_identification id, ec_customer_service_issues i left join ec_cs_issue_type_map m on (i.issue_id = m.issue_id)
+      where i.user_identification_id = id.user_identification_id
+      and id.user_id = :user_id
+      order by i.issue_id
+    </querytext>
+  </fullquery>
+
+  <fullquery name="customer_service_issue">
+    <querytext>
+      select i.issue_id, i.open_date, i.close_date, m.issue_type
+      from ec_customer_service_issues i left join ec_cs_issue_type_map m
+      on (i.issue_id = m.issue_id)
+      where i.user_identification_id = :user_identification_id
+      order by i.issue_id
+    </querytext>
+  </fullquery>
   
 </queryset>