Index: openacs-4/contrib/packages/project-manager/www/processes-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/packages/project-manager/www/Attic/processes-postgresql.xql,v
diff -u -r1.1.4.1 -r1.1.4.2
--- openacs-4/contrib/packages/project-manager/www/processes-postgresql.xql	2 Jul 2004 23:13:49 -0000	1.1.4.1
+++ openacs-4/contrib/packages/project-manager/www/processes-postgresql.xql	26 Oct 2004 01:21:11 -0000	1.1.4.2
@@ -9,9 +9,11 @@
         p.one_line,
         p.description,
         p.party_id,
-        to_char(p.creation_date,'YYYY-MM-DD') as creation_date_ansi
+        to_char(p.creation_date,'YYYY-MM-DD') as creation_date_ansi,
+        (select count(*) from pm_process_instance i where i.process_id =
+        p.process_id) as instances
         FROM 
-        pm_process p
+        pm_process_active p
         ORDER BY
         p.one_line        
     </querytext>