Why Does the value Column in the ISSUE_FIELD_HISTORY Table Contain null Values?

Question

Why does the value column in the ISSUE_FIELD_HISTORY table contain null values?

Environment

Connector: Jira

Answer

When we sync a new issue for the first time, we populate all available fields and values of the ISSUE_FIELD_HISTORY table using the data returned by Jira API's issue endpoint. If one or more fields don't apply to the new issue, we populate the associated value columns with null values.

We sync subsequent changes to the issue using the changelog endpoint. If some fields still don't apply to the issue, we continue populating the associated value column with null values.