oracle8.1.6
select r.rule_id, r.rule_name, rt.result_id, rt.qs_id,
rt.rule_def_id, rt.active_p,r.asm_id,q.question_text as
description, (select label value from survey_question_choices
where question_id=rt.qs_id and choice_id=rt.result_id) as
value,ra.rule_id,ra.group_id,ra.notify_p,ra.active_p,ra.rule_action_id,
ra.action_type, (select pretty_name from dotlrn_communities_all where
community_id=ra.group_id) as name
from rules r,rules_triggers rt,rules_actions ra,survey_questions q,survey_sections ss
where rt.rule_id=r.rule_id and rt.rule_id=:rule_id
and q.question_id = rt.qs_id and ss.survey_id = r.asm_id and
ss.section_id = q.section_id and ra.rule_id=r.rule_id and
ra.rule_id=:rule_id and rt.rule_id=ra.rule_id
select
ra.rule_id,ra.group_id,ra.notify_p,ra.active_p,ra.rule_action_id,ra.action_type, (select pretty_name from dotlrn_communities_all where
community_id=ra.group_id) as name
from rules r,rules_actions ra
where ra.rule_id=r.rule_id and ra.rule_id=:rule_id
select sq.question_id as qs_id, sq.question_text as description
from survey_questions sq
where sq.section_id = (select section_id from survey_sections where
survey_id=(select asm_id from rules where rule_id=:rule_id)) and sq.question_id not
in (select qs_id from rules_triggers where rule_id=:rule_id) and (select
count(choice_id) from survey_question_choices where question_id =
sq.question_id) > 0
select choice_id as result_id, label as value
from survey_question_choices
where question_id = :selected_qs