Jira: Daily Issue Field History

Description

• Each record represents a snapshot of an issue's selected fields (as specified in the issue_history_columns variable + sprint and status by default) on a given day. Each issue will have a record for every day in which it was open and/or being updated. For currently open issues, the latest date will be the current date, and for closed issues, this will be the last time the issue was resolved OR updated in any way (plus a configurable buffer afterward, set to a month by default). Note: this is an incremental model.

Supported Data Sources

• Jira

Columns

Type	Name	Description
DATE	date_day	Date on which the issue had these field values.
INTEGER	issue_id	Foreign key referencing the ID of the issue with these values.
STRING	status	The name of the status that an issue has on a given day.
STRING	status_id	The ID of the status that an issue has on a given day.
STRING	sprint	The ID of the sprint that an issue is slotted into on a given day.
STRING	summary
STRING	story_points
STRING	components
STRING	issue_day_id	Surrogate key hashed on date_day and issue_id