Index: openacs-4/packages/evaluation/www/admin/grades/grades-reports-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/evaluation/www/admin/grades/grades-reports-postgresql.xql,v
diff -u -r1.2 -r1.3
--- openacs-4/packages/evaluation/www/admin/grades/grades-reports-postgresql.xql	12 May 2004 02:07:45 -0000	1.2
+++ openacs-4/packages/evaluation/www/admin/grades/grades-reports-postgresql.xql	31 May 2004 17:04:58 -0000	1.3
@@ -57,4 +57,21 @@
       </querytext>
 </fullquery>
 
+<fullquery name="community_grades_report">      
+      <querytext>
+
+	select cu.first_names||', '||cu.last_name as student_name
+	$sql_query
+    from cc_users cu,
+	registered_users ru,
+        dotlrn_member_rels_approved app
+    where app.community_id = :community_id
+      and app.user_id = ru.user_id
+      and app.user_id = cu.person_id
+      and app.role = 'student'		
+    $orderby
+
+      </querytext>
+</fullquery>
+
 </queryset>