Index: openacs-4/packages/tasks/www/processes-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/tasks/www/processes-postgresql.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/tasks/www/processes-postgresql.xql	27 Jul 2005 13:44:59 -0000	1.1
+++ openacs-4/packages/tasks/www/processes-postgresql.xql	25 Sep 2005 23:49:23 -0000	1.2
@@ -4,19 +4,16 @@
 
 <fullquery name="process_query">
     <querytext>
-        SELECT
-        p.process_id,
-        p.one_line,
-        p.description,
-        p.party_id,
-        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,
-        person__name(party_id) as owner_name
-        FROM 
-        pm_process_active p
-        ORDER BY
-        p.one_line        
+        select p.process_id, p.title, o.creation_user,
+               person__name(o.creation_user) as creator_name, p.description,
+               to_char(o.creation_date, 'YYYY-MM-DD') as creation_date_ansi,
+               (select count(*)
+                from t_process_instances pi
+                where pi.process_id = p.process_id) as instances
+        from t_processes p, acs_objects o
+        where p.process_id = o.object_id
+        and p.workflow_id is not null
+        order by lower(p.title)
     </querytext>
 </fullquery>