Edit on GitHub
History Tables Not Synced for Some Fieldslink
Updated 11 days ago
Questionlink
Why are history tables not synced to the destination for all fields in Jira?
Answerlink
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
):
- The ID of that field will be synced to the table
ISSUE
orISSUE_[FIELD_NAME]
- 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.