Method getPersonBySlug

server/src/db/community-db.ts:336–378

(slug: string, viewerUserId?: string)

  }

  async getPersonBySlug(slug: string, viewerUserId?: string): Promise<PersonDetail | null> {
    // Base user data
    const userResult = await query<PersonListItem & { interests: string[]; linkedin_url: string | null; twitter_url: string | null; github_username: string | null }>(
      `SELECT u.workos_user_id, u.slug, u.first_name, u.last_name, u.headline, u.bio,
              u.avatar_url, u.expertise, u.interests, u.city, u.country,
              u.open_to_coffee_chat, u.open_to_intros, u.linkedin_url, u.twitter_url,
              u.github_username, CASE WHEN o.is_personal THEN NULL ELSE o.name END as organization_name
       FROM users u
       LEFT JOIN organizations o ON o.workos_organization_id = u.primary_organization_id
       WHERE u.slug = $1
         AND (u.is_public = true OR u.workos_user_id = $2)`,
      [slug, viewerUserId || '']
    );

    const user = userResult.rows[0];
    if (!user) return null;

    // Fetch enrichments in parallel
    const [points, badges, workingGroups, events, perspectives, registryContributions, connectionStatus] = await Promise.all([
      this.getUserPoints(user.workos_user_id),
      this.getUserBadges(user.workos_user_id),
      this.getUserWorkingGroups(user.workos_user_id),
      this.getUserEvents(user.workos_user_id),
      this.getUserPublishedContent(user.workos_user_id),
      this.getUserRegistryContributions(user.workos_user_id),
      viewerUserId ? this.getConnectionStatus(viewerUserId, user.workos_user_id) : Promise.resolve(null),
    ]);

    return {
      ...user,
      total_points: points,
      tier: this.getTierName(points),
      badges,
      working_groups: workingGroups,
      events,
      perspectives,
      registry_contributions: registryContributions,
      profile_completeness: this.getProfileCompleteness(user),
      connection_status: connectionStatus?.status || null,
      connection_id: connectionStatus?.id || null,
      connection_direction: connectionStatus?.direction || null,
    };
  }

  private async getUserWorkingGroups(userId: string): Promise<{ id: string; name: string; slug: string }[]> {
    const result = await query<{ id: string; name: string; slug: string }>(