postgresql7.4
select count(eg.grade_id)
from evaluation_gradesx eg, acs_objects ao
where content_revision__is_live(eg.grade_id) = true
and eg.item_id = ao.object_id
and ao.context_id = [ad_conn package_id]
select eg.grade_id,
eg.grade_plural_name,
eg.weight
from evaluation_gradesx eg, acs_objects ao
where content_revision__is_live(eg.grade_id) = true
and eg.item_id = ao.object_id
and ao.context_id = :package_id
order by grade_plural_name
, [lc_numeric trunc(evaluation__grade_total_grade(cu.user_id,$grade_id),2)] as grade_$grade_id
, [lc_numeric trunc(evaluation__class_total_grade(cu.user_id,$package_id),2)] as total_grade
select cu.first_names||', '||cu.last_name as student_name
$sql_query
from cc_users cu
$orderby
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