Issue

History tables are not being synced to the destination for all fields in Jira.

Environment

Connector: Jira

Resolution

This happens when a field in Jira has a non-array type, meaning only one value can be selected. As such, it will be synced as a column in the ISSUE table. For all field types, it will be synced to the separate ISSUE_[Field_Name] table.

If the value of the field is an entity that has its own properties, (e.g. field_option):

1. The ID of that field will be synced to the table ISSUE or ISSUE_[FIELD_NAME]

2. The properties of that field will be synced to the related dimension table (e.g., the file_option table)

If the field value is a string, the ISSUE table will have the field value synced into the field in the related column.