Question regarding raw_value_before and raw_value_after columns in the cmn_audit table

Products

• Clarity PPM SaaS

Issue/Introduction

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.

Environment

Release : 15.9.1

Component : CA PPM SAAS STUDIO

Resolution

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.