# Epic SPPM-17 - Create and share custom project lists with new filter options

Project: Stream Project Portfolio Management
Status: closed
URL: https://community.openproject.org/work_packages/SPPM-17

## Detailed specification

### Motivation and background information

### Acceptance criteria

### Out of scope

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

## Planning

| Attribute | Value |
| --- | --- |
| Roadmap |  |
| Date |  |
| Votes |  |
| List | cProject |
| Target versions | 15.0.0 |
| Relevance |  |

## Subitems

| ID | Type | Subject | Status | Assignee | Target versions | Project | Priority | Spent time |
| --- | --- | --- | --- | --- | --- | --- | --- | --- |
| SPPM-30 | Feature | Use the new defaults on the project index page for page header and sidebar | closed |  | 13.2.0 | Stream Project Portfolio Management | Medium |  |
| SPPM-23 | Feature | Have persisted project lists (only filters) | closed |  | 13.3.0 | Stream Project Portfolio Management | Medium |  |
| SPPM-31 | Feature | Move filters toggle and "+Project"-Button from header into content | closed |  | 13.3.0 | Stream Project Portfolio Management | Medium |  |
| SPPM-38 | Feature | Clean menu structure on project lists page | closed |  | 13.3.0 | Stream Project Portfolio Management | Medium |  |
| SPPM-26 | Feature | Allow columns to be changed (selection, order) and persisted | closed |  | 13.4.0 | Stream Project Portfolio Management | Medium |  |
| SPPM-35 | Feature | Project list: Truncate long text fields and disable expand action | closed |  | 13.4.0 | Stream Project Portfolio Management | Medium |  |
| SPPM-40 | Feature | Modification message and "save as" button upon modification | closed |  | 13.4.0 | Stream Project Portfolio Management | Medium |  |
| SPPM-42 | Feature | Use primer modal for project list deletion | closed |  | 13.4.0 | Stream Project Portfolio Management | Medium |  |
| SPPM-43 | Feature | Optimize column truncation for text that is not previewable | closed |  | 13.4.0 | Stream Project Portfolio Management | Medium |  |
| SPPM-45 | Feature | Fine-tuning of truncation feature in project list and project overview | closed |  | 14.0.0 | Stream Project Portfolio Management | Medium |  |
| SPPM-27 | Feature | Persist the sort order of project lists | closed |  | 14.1.0 | Stream Project Portfolio Management | Medium |  |
| SPPM-36 | Feature | Changing a persisted list (only own) | closed |  | 14.1.0 | Stream Project Portfolio Management | Medium |  |
| SPPM-29 | Feature | Allow renaming persisted project lists | closed |  | 14.2.0 | Stream Project Portfolio Management | Medium |  |
| SPPM-28 | Feature | Starring favorite project lists | closed |  | 14.3.0 | Stream Project Portfolio Management | Medium |  |
| SPPM-32 | Feature | Shared project lists | closed |  | 14.3.0 | Stream Project Portfolio Management | Medium |  |
| SPPM-61 | Feature | Select/Exclude projects in project list explicitly via filter | closed |  | 14.4.0 | Stream Project Portfolio Management | Medium |  |
| SPPM-62 | Feature | Always visible text filter in project list | closed |  | 14.5.0 | Stream Project Portfolio Management | Medium |  |
| SPPM-76 | Feature | Make Project List and header view turbo aware | closed |  | 14.5.0 | Stream Project Portfolio Management | Medium |  |
| SPPM-54 | Feature | Free choice of columns in exports | closed |  | 14.6.0 | Stream Project Portfolio Management | Medium |  |
| SPPM-81 | Feature | Turn project list into favorite without reloading the page | closed |  | 14.6.0 | Stream Project Portfolio Management | Medium |  |
| SPPM-37 | Feature | Quick action table headers | closed |  | 15.0.0 | Stream Project Portfolio Management | Medium |  |
| SPPM-39 | Feature | Zen mode for project lists page | closed |  | 15.1.0 | Stream Project Portfolio Management | Medium |  |

## Bugs and other work packages

| ID | Type | Subject | Status | Assignee | Target versions | Module |
| --- | --- | --- | --- | --- | --- | --- |
| SPPM-50 | Bug | Changing a saved project list does not trigger the "Save as" button | closed |  | 14.1.0 |  |
| SPPM-47 | Bug | Removing a project custom field stored as a filter in a project list leads to wrong counter value | closed |  | 14.1.0 |  |
| SPPM-72 | Bug | Share modal subheader text is misplaced on mobile + user placeholder text overlaps | closed |  | 14.3.0 |  |
| SPPM-84 | Bug | Column ordering broken on project list | closed |  | 14.5.0 |  |
| SPPM-79 | Bug | Time based filters like "Created on" don't trigger a result update while typing | closed |  | 14.5.0 |  |
| SPPM-46 | Code maintenance | Separate filtering from projections in queries | on hold | Jens Ulferts | Product Backlog |  |
| SPPM-34 | Code maintenance | Harmonize work package query implementation with project query implementation | new |  | Product Backlog |  |
| SPPM-41 | Bug | Duplicate scrollbars on project list page | rejected |  |  |  |
| SPPM-52 | Code maintenance | CopyServices should take override parameters | specified |  |  |  |
| SPPM-66 | Code maintenance | Find a unified way how to handle the conflict between persisted query model class and all supporting classes (i.e. filters) | new |  |  |  |

## Details

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

## People

| Attribute | Value |
| --- | --- |
| Assignee |  |
| Accountable | Niels Lindenthal |
| Product manager |  |
| Feature Lead |  |
| Designer | Marc Alcobé |
| Developers | OP Dev Polaris Team |
| Requested by |  |
| Interest by |  |

## Estimates and progress

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

## Description

**As a** project portfolio manager

**I want to** easily create lists of my projects with filters

**So that** I can structure the large number of projects in portfolios which are easier to manage.

### Acceptance criteria and implementation steps

#### Step 1: Project lists

- [x] Create project lists (<mention class="mention" data-id="51666" data-type="work_package" data-text="#51666">#51666</mention>)
- [x] Open project lists from the sidebar (<mention class="mention" data-id="51666" data-type="work_package" data-text="#51666">#51666</mention>)
- [x] New global roles to create project lists (<mention class="mention" data-id="51779" data-type="work_package" data-text="#51779">#51779</mention>)
  - [x] View
  - [x] Manage (create, edit, update, delete)
- [x] Rename project lists (<mention class="mention" data-id="51673" data-type="work_package" data-text="#51673">#51673</mention>)
- [x] Delete project lists (<mention class="mention" data-id="51666" data-type="work_package" data-text="#51666">#51666</mention>)
- [x] There are two new global permissions
  - [x] Create public project lists (<mention class="mention" data-id="51779" data-type="work_package" data-text="#51779">#51779</mention>)
  - [x] Create private project lists (<mention class="mention" data-id="51666" data-type="work_package" data-text="#51666">#51666</mention>)
- [x] Quick table settings from the column header (<mention class="mention" data-id="52147" data-type="work_package" data-text="#52147">#52147</mention>)
  - [x] Remove column
  - [x] Change sort order (ascending, descending)
  - [x] Add column
  - [x] Change order of columns

### Step 2: Additional project filter (<mention class="mention" data-id="55233" data-type="work_package" data-text="#55233">#55233</mention>)

- [x] Extend the project filter to select individual projects.
  - [x] **Example 1:** Manual selection of Project A, C and F.
  - [x] **Example 2:** Filter of all projects in status red but remove Project B from the list even though Project B meets the filter criteria.

### Step 3: Always visible text filter (<mention class="mention" data-id="55234" data-type="work_package" data-text="#55234">#55234</mention>)

- [x] There is a filter text field that is always visible.
- [x] The search button opens the current filter box.
- [x] Primer filter search field "Filter by text" above the project list
  - [x] Example: Enter text "Köln" into the field. This searches for all projects in that list that have this search string in their "Project  
    name".

### Step 4: Favorite project lists  (<mention class="mention" data-id="51672" data-type="work_package" data-text="#51672">#51672</mention>)

- [x] Project lists can be "favored"/"starred"
    - This is a personal setting. It is not visible to other users.
  
    - Indicate favoured project lists in the sidebar with a star icon.

### Step 5: Shared project lists (<mention class="mention" data-id="51779" data-type="work_package" data-text="#51779">#51779</mention>)

- [x] A user with the global permission "Share project lists" can share a project list with other users and groups.
    - There is form that allows to select users and groups the project list is shared with (similar to sharing work packages).
  
    - Users can access the project lists that are shared with them in the sidebar.
  
    - **Info**: The sharing of project lists only apply to the project lists. It does not give the users access to the projects itself. So differentusers can see different results when clicking on shared project lists based on their individual project roles.

## Figma and Visuals

<https://www.figma.com/file/YCCMdJWkrtP9YSmf49Od0i/Project-lists?type=design&node-id=470-13037&mode=design>
