**As** a project portfolio manager
**I want to** have filters for stages 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

* Begin of the insertionAvailable filters:

1. ProjectsEnd of the insertion Begin of the deletion Filter for all projectsEnd of the deletion that are Begin of the deletion currentlyEnd of the deletion in any stage/gate Begin of the insertion

End of the insertion Begin of the deletion

End of the deletion * Begin of the insertion\[open\] NameEnd of the insertion Begin of the deletion FilterEnd of the deletion for Begin of the insertionthe filter

2. ProjectsEnd of the insertion Begin of the deletion all projectsEnd of the deletion that are Begin of the deletion currentlyEnd of the deletion in Begin of the insertiona specific Stage/Gate

* This will require having one filter per Stage/Gate that are dynamically added/removed when new stages/gates are added.

* The activation/deactivation of a Stage/GateEnd of the insertion Begin of the deletion "initialization"/"execution"/... today orEnd of the deletion within Begin of the insertiona project does not factor into the availability of the filter. As soon as the stage/gate is created in the administration, the filter is available.

End of the insertion Begin of the deletion some time interval

End of the deletion * Begin of the insertion\[open\] Name forEnd of the insertion Begin of the deletion For both filters,End of the deletion the Begin of the insertionfilter.

* Operators for both filters:End of the insertion Begin of the deletion operators areEnd of the deletion

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

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

End of the insertion Begin of the deletion

End of the deletion * Begin of the insertionThe calculation for the current week takes the "Week starts on" Setting into account.

* \[open\] The alternative would be to only find projects where the interval formed by the start and the end date is completely enclosed in the current week.

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

* \[open\] findEnd of the insertion Begin of the deletion (differentEnd of the deletion term Begin of the insertionfor this operator -End of the insertion Begin of the deletion to denote thatEnd of the deletion the user would want to know if something happens on that Begin of the insertionday.

* betweenEnd of the insertion Begin of the deletion day)End of the deletion - Begin of the insertiontwo values: Matches if the specified stage/gate's (for 2.) or if any stage/gate's (for 1.) interval formed by start and end date overlap the date interval created by the two values.End of the insertion Begin of the deletion one valueEnd of the deletion

* \[open\] Begin of the insertionThe alternative would be to onlyEnd of the insertion find Begin of the insertionprojects where the interval formed by the start and the end date is completely enclosed in the interval created by the two values.

End of the insertion Begin of the deletion term for this operator

End of the deletion * Begin of the insertionThis question indicates that it might be a good idea to add another operator to distinguish theEnd of the insertion Begin of the deletion between -End of the deletion two Begin of the insertioncases.

End of the insertion Begin of the deletion values

End of the deletion * is empty - no value Begin of the insertionrequired: Matches if the specified stage/gate (for 2.) or if any stage/gate (for 1.) has no value set.

* Restrictions

* In case a stage/gate is disabled in a project the value that stage/gate might have in 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:

* \[open\] 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.End of the insertion