Convert the Cosplayers listing page from loading all records at once to infinite scroll with server-side pagination, and add search/sort controls.
Dependencies
Depends on #84 (pagination DTO sort parameters) — must be merged first
Supersedes #54 (Person list endpoint pagination) — will close it via PR
Current Problem
PersonController.GetAll loads ALL people into memory via PersonRepository.GetAllVisible() which calls .ToList() then filters client-side. No pagination, no search, no sorting.
Sort Options
Field
Query param value
SQL OrderBy
Name
name
p.Name
Created
created
p.CreatedAt
Album Count
albums
p.Albums.Count
Default: name ASC (alphabetical).
Search
Text input filters cosplayers by name substring
Live filtering as user types
UI
Convert to infinite scroll (JS intersection observer, matching Albums page pattern)
Add search/sort toolbar (reusing SortFilterBar.razor from the Albums PR)
Backend Changes
IPersonRepository / PersonRepository — add SearchQuery method with sort/search/pagination, push access-level filtering to SQL where possible
## Objective
Convert the Cosplayers listing page from loading all records at once to infinite scroll with server-side pagination, and add search/sort controls.
## Dependencies
- Depends on **#84** (pagination DTO sort parameters) — must be merged first
- Supersedes **#54** (Person list endpoint pagination) — will close it via PR
## Current Problem
`PersonController.GetAll` loads ALL people into memory via `PersonRepository.GetAllVisible()` which calls `.ToList()` then filters client-side. No pagination, no search, no sorting.
## Sort Options
| Field | Query param value | SQL OrderBy |
|---|---|---|
| Name | `name` | `p.Name` |
| Created | `created` | `p.CreatedAt` |
| Album Count | `albums` | `p.Albums.Count` |
Default: `name` ASC (alphabetical).
## Search
- Text input filters cosplayers by name substring
- Live filtering as user types
## UI
- Convert to infinite scroll (JS intersection observer, matching Albums page pattern)
- Add search/sort toolbar (reusing `SortFilterBar.razor` from the Albums PR)
## Backend Changes
- `IPersonRepository` / `PersonRepository` — add `SearchQuery` method with sort/search/pagination, push access-level filtering to SQL where possible
- `PersonController.GetAll` — accept `PersonSearchParametersDto`, return paginated results
- `PersonService.GetAllAsync` — accept `page`, `pageSize`, `search`, `sortBy`, `sortAsc`
## Closes
- Closes #54
Ai_Agent
added the AI Gen label 2026-07-11 11:07:02 +00:00
Blocking a user prevents them from interacting with repositories, such as opening or commenting on pull requests or issues. Learn more about blocking a user.
Objective
Convert the Cosplayers listing page from loading all records at once to infinite scroll with server-side pagination, and add search/sort controls.
Dependencies
Current Problem
PersonController.GetAllloads ALL people into memory viaPersonRepository.GetAllVisible()which calls.ToList()then filters client-side. No pagination, no search, no sorting.Sort Options
namep.Namecreatedp.CreatedAtalbumsp.Albums.CountDefault:
nameASC (alphabetical).Search
UI
SortFilterBar.razorfrom the Albums PR)Backend Changes
IPersonRepository/PersonRepository— addSearchQuerymethod with sort/search/pagination, push access-level filtering to SQL where possiblePersonController.GetAll— acceptPersonSearchParametersDto, return paginated resultsPersonService.GetAllAsync— acceptpage,pageSize,search,sortBy,sortAscCloses