[Feature] Add `Assigned to Me` Filter Support to `/gobounties/all` endpoint

[Ekep-Obasi]

Description

Add support for filtering bounties by current authenticated user's assignments in the /gobounties/all endpoint.

Technical Details

• Add new query parameter to filter bounties assigned to authenticated user
• Extend existing GetAllBounties function to handle new filter
• Ensure proper authentication validation
• Unit tests for GetAllBounties with assignedToMe parameter

Implementation Notes

• Add new query parameter myAssigned=true to existing endpoint
• Update SQL query to include condition: AND assignee = [current_user_id] when filter is active
• Maintain compatibility with existing filter combinations

Acceptance Criteria

• /gobounties/all endpoint accepts new myAssigned parameter
• Returns only bounties assigned to authenticated user when filter is active
• Maintains proper interaction with existing filters
• Returns appropriate error for unauthenticated users
• Maintains existing pagination functionality

Dependencies

• Requires Frontend implementation: Link to frontend issue

[humansinstitute]

Bounty: https://community.sphinx.chat/bounty/3334

[abhishek818]

@humansinstitute is this open to external contributions ?

[cybercraftsolutionsllc]

Opened PR: #2791

This adds myAssigned=true support to /gobounties/all, requiring auth only for that assigned-to-me filter and keeping the existing public bounty list behavior intact.

Validation run:

• go test ./handlers -run TestGetAllBountiesMyAssignedAuth -count=1
• go test ./handlers -run '^$' -count=1
• go test ./db -run '^$' -count=1
• git diff --check

[newmattock]

Submitted PR #2773 for this backend bounty: #2773

It adds authenticated myAssigned=true support to /gobounties/all, keeps existing public bounty-list behavior unchanged, and pairs with frontend PR stakwork/sphinx-tribes-frontend#1581.

Validation from the PR:

• go test ./handlers -run 'TestGetAllBounties' -count=1
• go test ./db -run '^$' -count=1
• gofmt -w db/db.go handlers/bounty.go handlers/bounty_test.go mocks/Database.go
• git diff --check -- db/db.go handlers/bounty.go handlers/bounty_test.go mocks/Database.go

[cybercraftsolutionsllc]

Confirmed this was already covered by #2773: #2773

I missed the earlier PR when submitting #2791. Sorry for the duplicate noise; I have closed my duplicate PR so review can stay focused on the prior submission.

[GautamKumarOffical]

Opened PR: #2802

Adds myAssigned=true query parameter to /gobounties/all to filter bounties by the authenticated user's assignments. Works alongside existing filters. Includes unit tests.