In cmn_audit table, we have two columns raw_value_before & raw_value_after. Please let us know what 'Raw' data related to?
Also if it is encrypted, is there a possibility to decrypt the data?
We are attempting to create custom portlet/report and wondering which columns we should use for our query.
Release : 15.9.1
Component : CA PPM SAAS STUDIO
raw_value_before and raw_value_after columns shouldn't be considered for custom reports as these are internal system columns which are used for expression evaluations.
With that said if you are looking to build a custom report and/or portlet you should get SQL Trace from the audit page when you navigate so you can see how system is mapping these values
to the real values you see in the UI.
Attached is a sample query from the Global Audit page for PostgreSQL.