Begin of the insertion### User Story

End of the insertion **As** an OpenProject user
**I want** to see in the Begin of the insertionlist view and theEnd of the insertion Gantt chart the changes that have been made when compared with a date in the past
**so that** I better understand the Begin of the deletion progress and theEnd of the deletion status Begin of the insertionand progressEnd of the insertion of my project.

Begin of the insertion### Extend the data model and the API to save and query historic values of work packagesEnd of the insertion Begin of the deletion **Solution concept:**End of the deletion

* Begin of the insertionExtendEnd of the insertion Begin of the deletion A user can set a date inEnd of the deletion the Begin of the insertiondata modelEnd of the insertion Begin of the deletion past.End of the deletion
* Begin of the insertionExtendEnd of the insertion Begin of the deletion ForEnd of the deletion the Begin of the deletion filter results also the values in the past are loaded from theEnd of the deletion API Begin of the deletion and presented in the frontend.End of the deletion
* Begin of the deletion There are two options to set a date in the past:
* A: A specific date, e.g. 2022-01-01
* A: A relative date, e.g. 7 days ago
* End of the deletion It is possible to filter on historic values in the past, e.g.
* All work packages that have been in status "scheduled" on 2022-01-01
* All work packages that were assigned to verion 12.1 and all work packages that have been added or removed since a specific date.

Begin of the insertion`Note: The largest uncertainty when planning and estimating this feature comes from the performance requirements. We need to ensure that this feature also worksEnd of the insertion Begin of the deletion **VisualEnd of the deletion for Begin of the insertionlarge organizations that have large data sets with a high number of concurrent requests.`

## Extend the work package filters to request historic values from the API

* Extend the view settings to save a query date in the past
* A: A specific date, e.g. 2022-01-01
* B: A relative date, e.g. 7 days ago
* Rebuild the work package queries to allow to request aEnd of the insertion list Begin of the insertionof work package including the changes.End of the insertion Begin of the deletion view**End of the deletion

<figure class="image Begin of the insertionop-uc-figure"><div class="op-uc-figure--content"><img class="op-uc-image" src="/api/v3/attachments/27111/content"></div></figure>

## Extend the work packages list view to display the changes

* Changes to the following work package core attributes are highlighted in a diff view.
* Status
* Assignee
* Accountable
* Project
* Start date
* Finish date
* Type
* Priority
* Work packages that were added or removed in the comparison time frame are highlighted (e.g. deliverables that were added to the project scope or features that were removed from a release).
* List the number of attributes that have been changed. This also includes changes to the work package description which is not shown in the list view.

<figure class="image op-uc-figure"><div class="op-uc-figure--content"><img class="op-uc-image" src="/api/v3/attachments/27112/content"></div></figure>

## Extend the Gantt view to display the changes

* Either start or finish date or both has been moved to the past.
* Either start or finish date or both has been moved to the future.
* Either start or finish date has been added
* Either start or finish date has been removed.

<figure class="imageEnd of the insertion op-uc-figure" style="width:75%;"><div class="op-uc-figure--content"><img class="op-uc-image" Begin of the insertionsrc="/api/v3/attachments/27113/content"></div></figure>

## Out of scope for this epic

* Track changes of relations between work packages.End of the insertion Begin of the deletion src="/api/v3/attachments/26988/content"></div></figure>End of the deletion