# Bug OP-16875 - Autocomplete not possible in project list filters in instances with many users

Project: OpenProject
Status: closed
URL: https://community.openproject.org/work_packages/OP-16875

## Open points

_No work packages_

## Details

| Attribute | Value |
| --- | --- |
| Date |  |
| Priority | Medium |
| Module |  |
| Target versions | 15.5.0 |
| Observed in versions | 15.3.0 |
| Sprint | 15.5.0 |
| Backlog bucket |  |
| Bug found in version (deprecated) | 15.3.x |
| Found in mobile app version |  |
| Follow-up feedback e-mail |  |
| Requires doc change | No |
| Accessibility | No |
| Pull preview |  |
| List |  |
| Labels |  |

## People

| Attribute | Value |
| --- | --- |
| Assignee |  |
| Accountable |  |
| Product manager |  |
| Developers | Jens Ulferts |
| Designer |  |
| Ordered by |  |
| Signed off by |  |
| Interest by |  |

## Planning

| Attribute | Value |
| --- | --- |
| Relevance |  |

## Costs

| Attribute | Value |
| --- | --- |
| Votes |  |
| Work |  |
| Labor costs |  |

## Description

### Steps to reproduce

1.  Login as a user with permissions to view all or at least many projects in your instance

2.  Go to the project list /projects page

3.  Click on "Filter" button

4.  Add a filter that allows filtering for user names

5.  Start typing in the input field but no autocomplete with user names will happen

### What is the buggy behavior?

**Preliminary remark:** The behaviour will only occur in instances with many users. In our production instance we have \> 14000 users. In our test instance, the filter is working since there are only around 300 users.

While selecting the filter that allows filtering for certain users, the list of users is being loaded in the background via an API-call to "<https://application.domain/api/v3/principals?filters=>" and all user ids are appended as values in the "filters"-GET parameter. This leads to a very long query string (around 35000 chars in our case) which is denied by our proxy due to security reasons (denial-of-service attacks, XSS-attacks, etc.). The API-call is then responded with a 502 error which crashes the autocomplete in the filter input field.

In such cases a POST request would be better since it's not as limited as GET requests are in terms of payload. 

### What is the expected behavior?

Autocomplete in the input field should work and allow filtering for user names.

### **Logs**

<img class="image_resized op-uc-image op-uc-image_inline" style="width:1107px;" src="/api/v3/attachments/384586/content">

### Screenshots and other files

*-*

### Environment information

<br>

**OpenProject installation type**

  - Packaged installation
    
      - What distribution? RHEL 9.5

**OpenProject version**

*15.3.2*

**Browser**

- [ ] Chrome
- [ ] Firefox
- [ ] Safari
- [ ] Mobile Safari
- [x] Other (please specify) Edge

**Operating System**

- [x] Windows
- [ ] Mac OS X
- [ ] Mobile iOS
- [ ] Mobile Android
- [ ] Linux (please specify distro)
- [ ] Chrome OS
- [ ] Other (please specify)

**Language**

*german*
