Exclude Deleted Users from profiles search Endpoint

Currently, deleted user profiles are being returned in search results via the profiles/search endpoint. To improve the quality of search results and avoid showing irrelevant profiles, we propose an update to this endpoint to ensure that profiles belonging to deleted users are excluded.

Problem:

• Deleted users' profiles can still be queried and appear in the results of the profiles/search endpoint.

• These profiles are irrelevant to active user interactions and contribute to a cluttered search experience.

Proposed Solution:

• Update the profiles/search endpoint to automatically filter out profiles associated with deleted users.

• Ensure that only active user profiles are returned in search results.

Acceptance Criteria:

1. Search Results: Profiles of deleted users should not be included in any search results returned from the profiles/search endpoint.

2. Data Integrity: Ensure that deleted users' data is still available through other relevant endpoints (e.g., historical data views, admin dashboards), but should not affect regular user-facing search.

3. Consistency: Apply this change to all instances of the profiles/search endpoint to ensure a consistent experience across the platform.

4. Performance: The filtering of deleted users should not significantly impact the performance or response times of the search endpoint.