Query to get list of template name, rule name, event, conditions and actions information
Version : 13000
DB : PGSQL
OUTPUT:
![](https://desk.zoho.com:443/support/ImageDisplay?downloadType=uploadedFile&fileName=1681992347087.png&blockId=6b6ce70e6c55f4e342a072cb851efe1d514fcb4b3e3a1220&zgId=c065ea7ed2255947&mode=view)
SELECT rd.rulename "Rule Name",
rd.usertype "Applies To",
rd.jscode "Script",
ry.ruletype "Event",
rff.fieldname"Field Condition",
rcm.condition_string "Condition",
rcfv.fieldvalue "field value",
raty.actionname "Action Name",
rff1.fieldname "Field Name in action",
rafmap.fieldvalue "Field Value in Action",
rtf.templatename "Template Name" FROM ruledata rd
LEFT JOIN RuleEventTypes ry ON ry.ruletypeid=rd.ruletypeid
LEFT JOIN RULETEMPLATESMAP rtm on rd.ruleid=rtm.ruleid
LEFT JOIN requesttemplate_list rtf ON rtf.templateid=rtm.templateid
left join RuleCriteriaMap rcm on rd.ruleid=rcm.ruleid
LEFT JOIN RuleFormField rff ON rcm.fieldid=rff.fieldid
left join RuleActionsMap ramap on rd.ruleid=ramap.ruleid
left join ruleactionfieldsmap rafmap on ramap.ruleactionid=rafmap.ruleactionid
LEFT JOIN RuleFormField rff1 ON rafmap.fieldid=rff1.fieldid
left join ruleactiontypes raty on ramap.ruleactiontypeid=raty.ruleactiontypeid
left join RuleCriteriaFieldValues rcfv on rcm.rulecriteriaid= rcfv.rulecriteriaid where rd.usertype = 'all_users'
order by 7
New to ADSelfService Plus?