Campaign listing, search, filter, and sort

[ayshadogo]

User Story:
As a visitor, I want to browse, search, filter, and sort campaigns via the API so that I can find causes I want to support.

Acceptance Criteria:

• GET /campaigns: page, limit, category, status, search (Postgres full-text search across title/description/story, min 3 characters, relevance-ordered), sortBy (newest/mostFunded/endingSoon); excludes DRAFT/SUSPENDED
• Response cached in Redis for 30s with all query params included in the cache key — test this specifically, since a partial key is a real bug that serves wrong results silently
• GET /campaigns/categories: categories with live counts

---

[ebubeb683-ship-it]

please i would to work on this task

[Glam26]

Hi! I'm interested in working on this issue.

My approach will be to:

Understand the current implementation and identify the required changes.
Implement the feature while maintaining backward compatibility.
Add comprehensive test coverage for the new behavior and potential edge cases.
Verify everything by running linting, tests, and the build before opening a PR.

I'd appreciate being assigned to this issue.

[JohnOluB]

I'll implement the GET /campaigns endpoint with pagination, filtering, sorting, and PostgreSQL full text search across the campaign fields, ensuring DRAFT and SUSPENDED campaigns are excluded by default. I'll also add the GET /campaigns/categories endpoint to return categories with live campaign counts.

For performance, I'll cache responses in Redis for 30 seconds using a cache key that includes all query parameters to avoid cache collisions. Finally, I'll add integration tests covering search, filters, sorting, pagination, category counts, and cache key generation to ensure the API behaves correctly.

[grantfox-oss]

🦊 GrantFox — @JohnOluB has been assigned to this issue as part of the Official Campaign | FWC26 campaign!

Next steps:

1. Open a Pull Request referencing this issue (e.g., Closes #22)
2. Your PR will be reviewed by the Dfunder maintainers

Good luck! Track your progress on GrantFox.

[grantfox-oss]

🦊 GrantFox — @Glam26 has been assigned to this issue as part of the Third Campaign campaign!

Next steps:

1. Open a Pull Request referencing this issue (e.g., Closes #22)
2. Your PR will be reviewed by the Dfunder maintainers

Good luck! Track your progress on GrantFox.