Activity Feed Service

Backend service that powers the activity feed by querying activities with cursor-based pagination on created_at for stable ordering under concurrent inserts. Joins activities, users, contacts, and activity_approvals tables, applying parameterized WHERE clauses for filtering. Enforces role-based data scoping so coordinators see only their local association and org admins see the full organization.

Feature: Activity Feed

activity-feed-service

• Execute paginated activity queries with cursor-based pagination on created_at
• Apply parameterized filter clauses for date range, peer mentor, activity type, and status
• Enforce role-based data scoping (coordinator sees local association, org admin sees full organization)
• Join activities with users, contacts, and activity_approvals for complete feed items
• Provide activity count and filter option metadata for the UI