OpenACS

arjun
committed
MAIN:arjun:20020726020231
on 26 Jul 02
Use new dotlrn_term::get_future_terms_as_options proc instead of nasty oracle only query
/evaluations/student-list-postgresql.xql (+1 -1)
48 48
49 49 <fullquery name="get_answer_info">     
50 50       <querytext>
51 51
52 52             select ea.data as answer_data,
53 53             ea.title as answer_title,
54 54             ea.revision_id,
55 55             to_char(ea.creation_date, 'YYYY-MM-DD HH24:MI:SS') as submission_date_ansi,
56 56             ea.last_modified as submission_date
57 57             from evaluation_answersi ea, cr_items cri
58 58             where ea.party_id = :party_id
59 59             and ea.task_item_id = :task_item_id
60 60             and cri.live_revision = ea.answer_id
61 61         
62 62       </querytext>
63 63 </fullquery>
64 64
65 65 <partialquery name="processed_clause">
66 66           <querytext>        
67 67
68                   and ea.party_id not in ([join $done_students ","])
  68                 and ev.party_id not in ([join $done_students ","])
69 69
70 70           </querytext>
71 71 </partialquery>
72 72
73 73 <fullquery name="get_not_evaluated_wa_students">     
74 74       <querytext>
75 75
76 76         select ev.party_id,
77 77         case when et.number_of_members = 1 then
78 78         (select last_name||', '||first_names from persons where person_id = ev.party_id)
79 79         else 
80 80         (select group_name from groups where group_id = ev.party_id)
81 81         end as party_name,
82 82         ev.party_id,
83 83         ev.data as answer_data,
84 84         ev.title as answer_title,
85 85         ev.revision_id,
86 86         to_char(ev.last_modified, 'YYYY-MM-DD HH24:MI:SS') as submission_date_ansi,
87 87         et.due_date,
88 88         ev.last_modified as submission_date