Issue Summary

When an issue is created in Jira and the issue values are unchanged since creation, these fields have their value populated with the Value's ID instead of a string in the issue history table. There also isn't a mapping table available to map the ID to the value.

However, the values are populated correctly if the values have been updated after issue creation.

Steps to Reproduce

1. Create an issue in Jira
2. Populate values into some of the fields (for example Owner Team = Support)
3. Wait for the data to sync with Data Lake
4. Query the issue history table for the above field and issue key.
   • the value (string) returns the ID of the value instead of the string
5. Query the issue field table for the above field and issue key

• • the value returned is a string (as seen in the UI)
• Next, update the Owner Team value. For example  (Support to Engineering)
• Query the issue history table for the above field and issue key.
  • the value (string) contains the string value

Expected Results

The value (string) field in the issue history table should show the string value as displayed in the issue field table for fields that have not been updated since the issue was created.

Actual Results

The value (string) in the issue history table shows the ID of the value for fields that have not been updated since the issue was created.

Workaround

One will be provided when available.