Index: openacs-4/packages/recruiting/www/admin/list-candidates.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/recruiting/www/admin/list-candidates.xql,v
diff -u -r1.2 -r1.3
--- openacs-4/packages/recruiting/www/admin/list-candidates.xql	31 Jul 2002 23:54:00 -0000	1.2
+++ openacs-4/packages/recruiting/www/admin/list-candidates.xql	1 Aug 2002 21:18:09 -0000	1.3
@@ -9,7 +9,15 @@
                   c.city,
                   c.state,
                   c.email,
-                  s.short_desc as status
+                  s.short_desc as status,
+                  (select count(*) 
+                     from recruiting_interviews i
+                    where i.candidate_id = c.candidate_id) as num_interviews,
+                  (select count(*) from recruiting_interviews i
+                    where i.candidate_id = c.candidate_id
+                      and (select count(*) 
+                             from recruiting_ratings r
+                            where r.interview_id = i.interview_id) != 0) as num_completed_interviews
              from recruiting_candidates c,
                   recruiting_status_types s
             where c.status = s.status_type_id