How Is Clarity Storing Audited Values for Multi-Valued Lookups (Mvl)?

Products

• Clarity FedRAMP
• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

How is Clarity storing audited values for multi-valued lookups (MVL)?

Environment

Any Clarity supported release.

Resolution

In the CMN_AUDIT table, you will see the new and old values for those MVL stored as a single ID (e.g.: 5000001) in the VALUE_BEFORE and VALUE_AFTER columns.

These IDs refer to entries to in the table ODF_AUD_MULTI_VAL_LOVS (the details of each row for each value in the VALUE_[BEFORE/AFTER] column in CMN_AUDIT table share the same ID in ODF_AUD_MULTI_VAL_LOVS).