Method getAllMappings

server/src/db/slack-db.ts:160–224

* Get all Slack user mappings

(options: {
    status?: SlackMappingStatus;
    includeBots?: boolean;
    includeDeleted?: boolean;
    search?: string;
    limit?: number;
    offset?: number;
  } = {})

   * Get all Slack user mappings
   */
  async getAllMappings(options: {
    status?: SlackMappingStatus;
    includeBots?: boolean;
    includeDeleted?: boolean;
    search?: string;
    limit?: number;
    offset?: number;
  } = {}): Promise<SlackUserMapping[]> {
    const conditions: string[] = [];
    const params: unknown[] = [];
    let paramIndex = 1;

    if (options.status) {
      conditions.push(`mapping_status = $${paramIndex++}`);
      params.push(options.status);
    }

    if (!options.includeBots) {
      conditions.push('slack_is_bot = false');
    }

    if (!options.includeDeleted) {
      conditions.push('slack_is_deleted = false');
    }

    if (options.search) {
      conditions.push(`(
        slack_email ILIKE $${paramIndex} OR
        slack_display_name ILIKE $${paramIndex} OR
        slack_real_name ILIKE $${paramIndex}
      )`);
      params.push(`%${escapeLikePattern(options.search)}%`);
      paramIndex++;
    }

    const whereClause = conditions.length > 0
      ? `WHERE ${conditions.join(' AND ')}`
      : '';

    let sql = `
      SELECT * FROM slack_user_mappings
      ${whereClause}
      ORDER BY
        CASE WHEN mapping_status = 'mapped' THEN 0
             WHEN mapping_status = 'pending_verification' THEN 1
             ELSE 2
        END,
        slack_real_name NULLS LAST,
        slack_display_name NULLS LAST,
        slack_email NULLS LAST
    `;

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

    if (options.offset) {