OpenACS

albertop
committed
MAIN:albertop:20070806113941
on 06 Aug 07
Problem with role in subgroups with evaluation
openacs-4/.../grades/grades-reports.xql (+1 -1)
34 34
35 35         select cu.first_names||', '||cu.last_name as student_name,
36 36         cu.user_id
37 37         $sql_query
38 38     from cc_users cu
39 39     $orderby
40 40
41 41       </querytext>
42 42 </fullquery>
43 43
44 44 <fullquery name="community_grades_report">     
45 45       <querytext>
46 46
47 47         select cu.first_names||', '||cu.last_name as student_name,
48 48         cu.user_id
49 49         $sql_query
50 50     from cc_users cu,
51 51         dotlrn_member_rels_approved app
52 52     where app.community_id = :community_id
53 53       and app.user_id = cu.person_id
54         and app.role = 'student'          
  54       and app.role in ('student','member')
55 55     $orderby
56 56
57 57       </querytext>
58 58 </fullquery>
59 59
60 60 </queryset>