ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Question regarding raw_value_before and raw_value_after columns in the cmn_audit table

book

Article ID: 213266

calendar_today

Updated On:

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.

Attachments

1619020009359__global_audit_trail_query_PG.txt get_app