postgresql7.3
select evaluation__party_name(ese.party_id,et.task_id) as party_name,
ese.party_id,
ese.grade,
ese.last_modified as evaluation_date,
et.online_p,
et.due_date,
ese.evaluation_id
from evaluation_tasks et,
evaluation_student_evalsi ese
where et.task_id = :task_id
and et.task_item_id = ese.task_item_id
and content_revision__is_live(ese.evaluation_id) = true
$orderby
select count(party_id) from evaluation_answers ea where ea.task_item_id = :task_item_id $processed_clause and content_revision__is_live(ea.answer_id) = true
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
where ea.party_id = :party_id
and ea.task_item_id = :task_item_id
and content_revision__is_live(ea.answer_id) = true
select count(*)
from evaluation_student_evals ese, evaluation_tasks et
where ese.task_item_id = et.task_item_id
and et.task_id = :task_id
and content_revision__is_live(ese.evaluation_id) = true
and ea.party_id not in ([join $done_students ","])
select evaluation__party_name(ea.party_id, :task_id) as party_name,
ea.party_id,
ea.data as answer_data,
ea.title as answer_title,
ea.revision_id,
to_char(ea.last_modified, 'YYYY-MM-DD HH24:MI:SS') as submission_date_ansi,
et.due_date,
ea.last_modified as submission_date
from evaluation_answersi ea,
evaluation_tasks et,
cr_items cri
where ea.task_item_id = et.task_item_id
and et.task_id = :task_id
and ea.data is not null
and cri.live_revision = ea.answer_id
$processed_clause