### User Story

**As** an OpenProject user
**I want** to Begin of the insertionbe able to see,End of the insertion Begin of the deletion seeEnd of the deletion in the list Begin of the deletion viewEnd of the deletion and the Gantt chart Begin of the insertionviews, an overview ofEnd of the insertion Begin of the deletion theEnd of the deletion changes that have been made Begin of the deletion whenEnd of the deletion compared Begin of the insertiontoEnd of the insertion Begin of the deletion withEnd of the deletion a Begin of the insertionspecificEnd of the insertion date in the past
**so that** I better understand the status and progress of my project.

### Extend the data model and the API to save and query historic values of work packages

* Extend the data model
* Extend the API
* It is possible to filter on historic Begin of the insertionvalues,End of the insertion Begin of the deletion values in the past,End of the deletion e.g.
* All work packages that have been in status "scheduled" on 2022-01-01
* All work packages that were assigned to Begin of the insertionversionEnd of the insertion Begin of the deletion verionEnd of the deletion 12.1 and all work packages that have been added or removed since a specific date.

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

## Extend Begin of the deletion theEnd of the deletion work package filters to request historic values from the API

* Extend the view Begin of the deletion settingsEnd of the deletion to Begin of the insertionallow users toEnd of the insertion Begin of the deletion save aEnd of the deletion query Begin of the insertionaEnd of the insertion date Begin of the insertion(inEnd of the insertion Begin of the deletion inEnd of the deletion the Begin of the insertionpast)End of the insertion Begin of the deletion pastEnd of the deletion
* A: A specific date, e.g. 2022-01-01
* B: A relative date, e.g. 7 days ago
* Rebuild Begin of the deletion theEnd of the deletion work package queries to allow Begin of the insertionrequestingEnd of the insertion Begin of the deletion to requestEnd of the deletion a list of Begin of the insertionrelevantEnd of the insertion work Begin of the insertionpackages,End of the insertion Begin of the deletion packageEnd of the deletion including the changes.

<figure class="image op-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 Begin of the deletion theEnd of the deletion 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 Begin of the insertionwithinEnd of the insertion Begin of the deletion inEnd of the deletion the Begin of the insertionspecifiedEnd of the insertion Begin of the deletion comparisonEnd of the deletion time Begin of the insertionperiod, ie, between the comparison date and today,End of the insertion Begin of the deletion frameEnd of the deletion 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 Begin of the insertionchanged in that time period.End of the insertion Begin of the deletion changed.End of the deletion This Begin of the insertionnumberEnd of the insertion also includes changes to the work package Begin of the insertiondescription, the details ofEnd of the insertion Begin of the deletion descriptionEnd of the deletion which Begin of the insertionwhich areEnd of the insertion Begin of the deletion isEnd of the deletion 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

* Begin of the insertionStart and/orEnd of the insertion Begin of the deletion Either start orEnd of the deletion finish date Begin of the insertionwasEnd of the insertion Begin of the deletion or both has beenEnd of the deletion moved to the past.
* Begin of the insertionStart and/orEnd of the insertion Begin of the deletion Either start orEnd of the deletion finish date Begin of the insertionwasEnd of the insertion Begin of the deletion or both has beenEnd of the deletion moved to the future.
* Begin of the insertionStart and/orEnd of the insertion Begin of the deletion Either start orEnd of the deletion finish date Begin of the insertionwasEnd of the insertion Begin of the deletion has beenEnd of the deletion added
* Begin of the insertionStart and/orEnd of the insertion Begin of the deletion Either start orEnd of the deletion finish date Begin of the insertionwasEnd of the insertion Begin of the deletion has beenEnd of the deletion removed.

<figure class="image op-uc-figure" style="width:75%;"><div class="op-uc-figure--content"><img class="op-uc-image" src="/api/v3/attachments/27113/content"></div></figure>

## Out of scope for this epic

* Track changes of relations between work packages.