How to arrange the condition string in sequenc to display all the conditions from POR_AMX_CONDITIONS
Summary:
Is there anyway to arrange the condition string in sequence as defined in the system to display all the conditions from POR_AMX_CONDITIONS.The condition string in table por_amx_rules is trucated is truncation conditions and not displaying all the condition
Content (please ensure you mask any confidential information):
Version (include the version you are using, if applicable):
we are currently on release 24B.
Code Snippet (add any code snippets that support your topic, if applicable):
SELECT
RTRIM( XMLAGG(
XMLELEMENT(E, condition_string || ', ').EXTRACT('//text()')
ORDER BY CONDITION_ID, CONDITION_NUMBER ASC
).GetClobVal(),
Tagged:
0