EI - Add data from PI that was removed on Capabilities

Issue Summary

This is reproducible on Data Center: yes

On the Enterprise Insights, we cannot identify the row showing that the Capability was removed from the PI. 

In the UI we have this information, like the image below:

Steps to Reproduce

1. Go to capabilities and select one
2. On the capability tab, remove the PI registered there and save.
3. Wait to sync the JA and the EI

Instance Details

• Jira Align Cloud
• Enterprise Insights

Expected Results

Access the data of the PI that was removed on the Capability.

Using a query like the below:

select cl.[Date Audit Event], ch.[Capability Name], ch.[Capability Description], ch.[Program Increment List], cl.[FK Capability ID], cl.[Detail Text]

from current_dw.[Capability History] ch LEFT JOIN current_dw.[Capability Log] cl on ch.[FK Capability ID] = cl.[FK Capability ID]

where ch.[FK Capability ID] = 887 AND cl.[Detail Text] = 'Program Increment Deleted'

Actual Results

There is no way to receive which PI was removed from Capabilities, only the message "Program Increment Deleted" is received. Using the query above, I only get the data below:

Workaround

Currently, there is no known workaround for this behavior. A workaround will be added here when available

Suggestion

The string "Program Increment(s) Removed" is saved on the internal table tblAuditLog, which is the source for the view [Capability Log], but the string "Program Increment Removed - DiegoReleaseWCapabilities_2022_Q2" (the piece they are looking for), is saved internally on the table tblAuditLogDetails, and from what I can see, this one is not used on EI at all.

It will be nice to have details of the table tblAuditLogDetails added to the [Capability Log], so with that, we will be able to get more information about the PI that was removed from Capabilities.