Connector Improvement: Jira isue_field_history - remove fields that don't track history or track the history of them
For those 4 field_ids (created, updated, resolved, statuscategorychanged), all of the records in the issue_field_history table have the is_active flag as TRUE. There are no records where is_active is FALSE.
My suggestion is to please either remove these timestamps from the issue_field_history table (as they are present in the issue table) or turn them into proper history records where we have all instances of the issue being updated, resolved or has its status category changed.
-
Rory hi
Do you still fetch data from issue_field_history?
If yes, how did you optimise that eat does not eat up from MAR and creates huge expense?
Thanks
Please sign in to leave a comment.
Comments
1 comment