Is is there any way we can retrieve all the conditions in sorted manner as per application.?

Summary:

We need to display all the conditions in the report according to the application, in a sorted manner. The sorted conditions are present in the table 

por_amx_rules

  but it is truncating as there are limitations with the table, where the maximum character length that can be extracted is 999.  

Is there any way we can retrieve all the conditions in sorted manner as per application.?

Each rule contains multiple conditions, which are not stored in the por_amx_conditions table. However, this table also truncates individual conditions if the character length exceeds 999.

When we edit the conditions we can see all the values which were provided in the condition. Which means it must be coming from some Oracle seeded table.   H