# Epic OP-2126 - Queries and filter on historic values

Project: OpenProject
Status: new
URL: https://community.openproject.org/work_packages/OP-2126

## Detailed specification

### Motivation and background information

### Acceptance criteria

### Out of scope

| Attribute | Value |
| --- | --- |
| Mockups |  |

## Planning

| Attribute | Value |
| --- | --- |
| Roadmap |  |
| Date |  |
| Votes | 4 |
| List |  |
| Target versions | Wish List |
| Sprint |  |
| Backlog bucket |  |
| Relevance |  |

## Subitems

_No work packages_

## Bugs and other work packages

_No work packages_

## Details

| Attribute | Value |
| --- | --- |
| Module |  |
| Enterprise plan |  |
| Labels |  |

## People

| Attribute | Value |
| --- | --- |
| Assignee |  |
| Accountable |  |
| Product manager |  |
| Feature Lead |  |
| Designer |  |
| Developers |  |
| Requested by |  |
| Interest by |  |

## Estimates and progress

| Attribute | Value |
| --- | --- |
| Work |  |

## Description

# Examples

## Team collaboration

  - Show me all work packages that were assigned to me yesterday.
  - Show me all work packages that had a specific status transition
      - New -\> all other status
      - all other status -\> closed
      - ...
  - Show me all tickets from yesterday a user was involved in (<mention class="mention" data-id="26324" data-type="work_package" data-text="#26324">#26324</mention>)

## Project management

  - Show me all phases and milestones that were postponed last week (due date has been increased)
  - Show me all rollouts that were deployed last week and all rollouts planned for the next to months (status new, scheduled, to be scheduled).

## Release management

  - Show me all work packages that were planned for a version at a specific time
  - Show me all work packages that were removed from a version since a specific time.
  - Show me all work packages that were added to a version after a specific date.

## **Incident Management**

  - Number of incidents in a specific status at a specific date.
  - Number of work packages that were resolved per day (Status changed from new or in progress to resolved, not from closed to resolved).

## **QA**

  - Number of open bugs at a specific date across a set of projects.
  - Number of work packages that were changed from “developed” to “test failed” per week.
