postgresql7.3
select ev.party_id,
case when et.number_of_members = 1 then
(select last_name||', '||first_names from persons where person_id = ev.party_id)
else
(select group_name from groups where group_id = ev.party_id)
end as party_name,
round(ev.grade,2) as grade,
ev.last_modified as evaluation_date,
et.online_p,
et.due_date,
ev.evaluation_id
from evaluation_tasks et,
evaluation_student_evalsi ev,
$roles_table
cr_items cri
where et.task_id = :task_id
and et.task_item_id = ev.task_item_id
$roles_clause
and cri.live_revision = ev.evaluation_id
$orderby
select 1 from dual where :submission_date > :evaluation_date
select 1 from dual where :submission_date > :due_date
select ea.data as answer_data,
ea.title as answer_title,
ea.revision_id,
to_char(ea.creation_date, 'YYYY-MM-DD HH24:MI:SS') as submission_date_ansi,
ea.last_modified as submission_date
from evaluation_answersi ea, cr_items cri
where ea.party_id = :party_id
and ea.task_item_id = :task_item_id
and cri.live_revision = ea.answer_id
and ea.party_id not in ([join $done_students ","])
select ev.party_id,
case when et.number_of_members = 1 then
(select last_name||', '||first_names from persons where person_id = ev.party_id)
else
(select group_name from groups where group_id = ev.party_id)
end as party_name,
ev.party_id,
ev.data as answer_data,
ev.title as answer_title,
ev.revision_id,
to_char(ev.last_modified, 'YYYY-MM-DD HH24:MI:SS') as submission_date_ansi,
et.due_date,
ev.last_modified as submission_date
from evaluation_answersi ev,
evaluation_tasks et,
$roles_table
cr_items cri
where ev.task_item_id = et.task_item_id
and et.task_id = :task_id
and ev.data is not null
$roles_clause
and cri.live_revision = ev.answer_id
$processed_clause
$orderby_wa
select et.task_name,
et.task_item_id,
eg.grade_id,
eg.grade_plural_name,
eg.weight as grade_weight,
et.weight as task_weight,
to_char(et.due_date, 'YYYY-MM-DD HH24:MI:SS') as due_date_ansi,
et.number_of_members,
et.online_p
from evaluation_grades eg, evaluation_tasks et, cr_items cri
where et.task_id = :task_id
and et.grade_item_id = eg.grade_item_id
and cri.live_revision = eg.grade_id
select g.group_name as party_name,
g.group_id as party_id
from groups g, evaluation_task_groups etg, evaluation_tasks et,
acs_rels map
where g.group_id = etg.group_id
and etg.group_id = map.object_id_one
and map.rel_type = 'evaluation_task_group_rel'
and etg.task_item_id = et.task_item_id
and et.task_id = :task_id
$not_in_clause
group by g.group_id, g.group_name