Index: openacs-4/packages/ae-portlet/www/ae-portlet-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ae-portlet/www/Attic/ae-portlet-postgresql.xql,v
diff -u -r1.2 -r1.3
--- openacs-4/packages/ae-portlet/www/ae-portlet-postgresql.xql	31 Jan 2006 01:41:53 -0000	1.2
+++ openacs-4/packages/ae-portlet/www/ae-portlet-postgresql.xql	4 Feb 2006 13:49:38 -0000	1.3
@@ -3,14 +3,15 @@
 <queryset>
 <rdbms><type>postgresql</type><version>7.1</version></rdbms>
 
-<fullquery name="open_asssessments">
+<fullquery name="open_assessments">
 	<querytext>
 	select cr.item_id as assessment_id, cr.title, cr.description, a.password,
 	       to_char(a.start_time, 'YYYY-MM-DD HH24:MI:SS') as start_time,
 	       to_char(a.end_time, 'YYYY-MM-DD HH24:MI:SS') as end_time,
 	       to_char(now(), 'YYYY-MM-DD HH24:MI:SS') as cur_time,
 	       cf.package_id, p.instance_name as community_name,
-	       sc.node_id as comm_node_id, sa.node_id as as_node_id
+	       sc.node_id as comm_node_id, sa.node_id as as_node_id, a.anonymous_p,
+	       a.assessment_id as assessment_rev_id
 	from as_assessments a, cr_revisions cr, cr_items ci, cr_folders cf,
 	     site_nodes sa, site_nodes sc, apm_packages p
 	where a.assessment_id = cr.revision_id