Documents list API: pagination, search, sort, personal/company scope #60

New Issue

2026-08-02T04:37:15-07:00

westfarn commented

2026-08-02 04:37:15 -07:00

Parent epic: chat_backend#42
Related: #46
Related FE: chat_web_app#93

Summary

GET /documents/ currently returns the full list for one workspace via ensure_workspace_for_user. Business users need personal and company docs; lists will grow with Drive sync — need pagination, search, and sort.

API changes

GET /documents/ (or scoped variant) should support:

Pagination — page / page_size (or limit/offset); response includes total count
Search — filter by filename / remote name (case-insensitive)
Sort — columns at least: name, date uploaded (created), processed, active
Scope — query param e.g. workspace=personal|company (or workspace id)
- Personal plan / non-company users: personal only
- Company members: can list personal workspace docs and company workspace docs separately
- Enforce auth: company scope only if user belongs to that company; uploads/mutations stay correctly scoped

Acceptance

Paginated response (not unbounded dump)
Search by name works
Sort by supported columns (asc/desc)
Personal vs company scope filter for business users
Tests for pagination, search, sort, and scope isolation

Parent epic: [chat_backend#42](https://git.aimloperations.com/ai_ml_operations/chat_backend/issues/42) Related: [#46](https://git.aimloperations.com/ai_ml_operations/chat_backend/issues/46) Related FE: [chat_web_app#93](https://git.aimloperations.com/ai_ml_operations/chat_web_app/issues/93) ## Summary `GET /documents/` currently returns the full list for one workspace via `ensure_workspace_for_user`. Business users need personal **and** company docs; lists will grow with Drive sync — need pagination, search, and sort. ## API changes `GET /documents/` (or scoped variant) should support: - **Pagination** — page / page_size (or limit/offset); response includes total count - **Search** — filter by filename / remote name (case-insensitive) - **Sort** — columns at least: name, date uploaded (`created`), processed, active - **Scope** — query param e.g. `workspace=personal|company` (or workspace id) - Personal plan / non-company users: personal only - Company members: can list personal workspace docs and company workspace docs separately - Enforce auth: company scope only if user belongs to that company; uploads/mutations stay correctly scoped ## Acceptance - [ ] Paginated response (not unbounded dump) - [ ] Search by name works - [ ] Sort by supported columns (asc/desc) - [ ] Personal vs company scope filter for business users - [ ] Tests for pagination, search, sort, and scope isolation

westfarn referenced this issue from ai_ml_operations/chat_web_app

2026-08-02 04:37:40 -07:00

Documents list: Personal/Company tabs, labeling, pagination, search, sort #93

westfarn referenced this issue from a commit

2026-08-02 04:44:21 -07:00

Add Drive sync progress, paginated docs list, and prompt heatmap API.

westfarn referenced a pull request that will close this issue

2026-08-02 04:44:27 -07:00

Drive sync progress + documents list API + prompt heatmap (#59, #60, #94) #61

westfarn closed this issue

2026-08-02 04:49:24 -07:00

westfarn referenced this issue from a commit