Method getUnmappedUsers

server/src/db/slack-db.ts:229–267

* Get unmapped Slack users (for nudge targeting)

(options: {
    excludeOptedOut?: boolean;
    excludeRecentlyNudged?: boolean;
    recentNudgeDays?: number;
    limit?: number;
  } = {})

   * Get unmapped Slack users (for nudge targeting)
   */
  async getUnmappedUsers(options: {
    excludeOptedOut?: boolean;
    excludeRecentlyNudged?: boolean;
    recentNudgeDays?: number;
    limit?: number;
  } = {}): Promise<SlackUserMapping[]> {
    const conditions: string[] = [
      "mapping_status = 'unmapped'",
      'slack_is_bot = false',
      'slack_is_deleted = false',
    ];
    const params: unknown[] = [];
    let paramIndex = 1;

    if (options.excludeOptedOut !== false) {
      conditions.push('nudge_opt_out = false');
    }

    if (options.excludeRecentlyNudged !== false) {
      const days = options.recentNudgeDays ?? 30;
      conditions.push(`(last_nudge_at IS NULL OR last_nudge_at < NOW() - INTERVAL '${days} days')`);
    }

    const whereClause = `WHERE ${conditions.join(' AND ')}`;

    let sql = `
      SELECT * FROM slack_user_mappings
      ${whereClause}
      ORDER BY nudge_count ASC, created_at ASC
    `;

    if (options.limit) {
      sql += ` LIMIT $${paramIndex++}`;
      params.push(options.limit);
    }

    const result = await query<SlackUserMapping>(sql, params);
    return result.rows;
  }

  /**
   * Get mapped users