Index: openacs-4/packages/ecommerce/www/admin/customer-service/statistics.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ecommerce/www/admin/customer-service/statistics.xql,v
diff -u -N -r1.1 -r1.2
--- openacs-4/packages/ecommerce/www/admin/customer-service/statistics.xql	10 Jul 2001 20:33:53 -0000	1.1
+++ openacs-4/packages/ecommerce/www/admin/customer-service/statistics.xql	30 Aug 2001 05:32:10 -0000	1.2
@@ -1,16 +1,33 @@
 <?xml version="1.0"?>
 <queryset>
 
+
+<fullquery name="get_actions_by_cs_rep_sql">
+      <querytext>
+
+      select customer_service_rep, first_names, last_name, count(*) as n_interactions
+      from ec_customer_serv_interactions, cc_users
+      where ec_customer_serv_interactions.customer_service_rep=cc_users.user_id
+      group by customer_service_rep, first_names, last_name
+      order by count(*) desc
+
+      </querytext>
+</fullquery>
+
 <fullquery name="get_issue_type_list">      
       <querytext>
+
       select picklist_item from ec_picklist_items where picklist_name='issue_type' order by sort_key
+
       </querytext>
 </fullquery>
 
  
 <fullquery name="get_important_info_list">      
       <querytext>
+
       select picklist_item from ec_picklist_items where picklist_name='info_used' order by sort_key
+
       </querytext>
 </fullquery>