**As** a project portfolio manager
**I want to** have filters for Begin of the insertionphasesEnd of the insertion Begin of the deletion stagesEnd of the deletion and gates on the project list
**so that** I can drill down on projects falling into a category (e..g all projects currently being closed)

**Acceptance criteria**

* The project list offers filters on stages and gates

* Available filters:

1. Projects that are in any Begin of the insertionphase/gateEnd of the insertion Begin of the deletion stage/gateEnd of the deletion

* Name: "Lifecycle: Any Begin of the insertionphaseEnd of the insertion Begin of the deletion stageEnd of the deletion or gate"

2. Projects that are in a specific Begin of the insertionphase/gateEnd of the insertion Begin of the deletion Stage/GateEnd of the deletion

* This will require having one filter per Begin of the insertionphase/gateEnd of the insertion Begin of the deletion Stage/GateEnd of the deletion that are dynamically added/removed when new Begin of the insertionphase/gatesEnd of the insertion Begin of the deletion stages/gatesEnd of the deletion are added.

* The activation/deactivation of a Begin of the insertionphase/gateEnd of the insertion Begin of the deletion Stage/GateEnd of the deletion within a project does not factor into the availability of the filter. As soon as the Begin of the insertionphase/gateEnd of the insertion Begin of the deletion stage/gateEnd of the deletion is created in the administration, the filter is available.

* Name for a stage: "Lifecycle stage: \[Name of the Begin of the insertionphase\]"End of the insertion Begin of the deletion stage\]"End of the deletion

* Name for a gate: "Lifecycle gate: \[Name of the gate\]"

* Operators for both filters:

* today - no value required: Matches if the specified Begin of the insertionphase/gateEnd of the insertion Begin of the deletion stage/gateEnd of the deletion (for 2.) or if any Begin of the insertionphase/gateEnd of the insertion Begin of the deletion stage/gateEnd of the deletion (for 1.) has a start date lower and an end date higher than today.

* this week - no value required: Matches if the specified Begin of the insertionphase/gate'sEnd of the insertion Begin of the deletion stage/gate'sEnd of the deletion (for 2.) or if any Begin of the insertionphase/gate'sEnd of the insertion Begin of the deletion stage/gate'sEnd of the deletion (for 1.) interval formed by start and end date overlap the date interval created by the current week.

* The calculation for the current week takes the "Week starts on" Setting into account.

* on  - one value required: Matches if the specified Begin of the insertionphase/gateEnd of the insertion Begin of the deletion stage/gateEnd of the deletion (for 2.) or if any Begin of the insertionphase/gateEnd of the insertion Begin of the deletion stage/gateEnd of the deletion (for 1.) has a start date lower and an end date higher than the provided date.

* between - two values: Matches if the specified Begin of the insertionphase/gate'sEnd of the insertion Begin of the deletion stage/gate'sEnd of the deletion (for 2.) or if any Begin of the insertionphase/gate'sEnd of the insertion Begin of the deletion stage/gate'sEnd of the deletion (for 1.) interval formed by start and end date are within the date interval created by the two values. If only the lower value is provided, it matches if the stage/gate's values are higher than the value. If only the upper value is provided, it matches if the Begin of the insertionphase/gate'sEnd of the insertion Begin of the deletion stage/gate'sEnd of the deletion values are lower than the value.

* is empty - no value required: Matches if the specified Begin of the insertionphase/gateEnd of the insertion Begin of the deletion stage/gateEnd of the deletion (for 2.) or if any Begin of the insertionphase/gateEnd of the insertion Begin of the deletion stage/gateEnd of the deletion (for 1.) has no value set.

* Restrictions

* In case a Begin of the insertionphase/gateEnd of the insertion Begin of the deletion stage/gateEnd of the deletion is disabled in a project the value that stage/gate might have set in the project is not found.

* The filters are only available if the user has the "View project phases and gates" permission in any project.

* Only values set for stages/gates within a project are only filtered on if the user has the "View project phases and gates" in that project.

* The filters are also available via the API v3.

* Those added filters need to be documented in the API documentation.


**Assumptions**

* A stage will always have no date or both dates set. It will never be the case that only the start or only the end date are set.


**Note**

* the filter for lifecycle columns has been [hard-coded to be disabled](https://github.com/opf/openproject/pull/17400). Remove the comment in `sort_helper`.