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, cu.user_id $sql_query from cc_users cu $orderby select cu.first_names||', '||cu.last_name as student_name, cu.user_id $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