Content
Feature SMA-576: Add an ability to filter projects by "Updated on" (UI) and "updated_at" (API) field
View differences
Updated by Jan Sandbrink 9 months ago
**As** an API user
**I want to** be able to filter existing projects by the latest updated time
**so that** it allows me to load only projects that were changed since my last check
**Acceptance criteria**
* to have a filter in `api/v3/projects` 'api/v3/projects' endpoint to be able to filter by date
* To have updated at available in project lists as filter and column that can be sorted by
**Technical notes**
Currently, we load all projects every time the app starts to keep them up to date. Based on Robin's feedback, we know that some customers have 13-14k projects. Loading such a large number of projects on every startup can take a significant amount of time. Even though this is an edge case, we still need to handle it. For example, even on _qa.openproject-edge.com_ with ~1k projects, it can still be critical.
To handle that we would like to have a filter by update\_at time. in this case mobile app can check only delta between latest fetch and current time. With that approach we expect to significantly reduce waiting time and server load .
**I want to** be able to filter existing projects by the latest updated time
**so that** it allows me to load only projects that were changed since my last check
**Acceptance criteria**
* to have a filter in `api/v3/projects`
* To have updated at available in project lists as filter and column that can be sorted by
**Technical notes**
Currently, we load all projects every time the app starts to keep them up to date. Based on Robin's feedback, we know that some customers have 13-14k projects. Loading such a large number of projects on every startup can take a significant amount of time. Even though this is an edge case, we still need to handle it. For example, even on _qa.openproject-edge.com_ with ~1k projects, it can still be critical.
To handle that we would like to have a filter by update\_at time. in this case mobile app can check only delta between latest fetch and current time. With that approach we expect to significantly reduce waiting time and server load .