Function resolveEscalationsForPerspective

server/src/db/escalation-db.ts:133–150

(
  perspectiveId: string,
  resolvedBy: string,
  notes: string
)

 * ones are left alone since a human may be actively working them.
 */
export async function resolveEscalationsForPerspective(
  perspectiveId: string,
  resolvedBy: string,
  notes: string
): Promise<number[]> {
  const result = await query<{ id: number }>(
    `UPDATE addie_escalations
     SET status = 'resolved',
         resolved_by = $2,
         resolved_at = NOW(),
         resolution_notes = $3,
         updated_at = NOW()
     WHERE perspective_id = $1 AND status = 'open'
     RETURNING id`,
    [perspectiveId, resolvedBy, notes]
  );
  return result.rows.map(r => r.id);
}

/**
 * Get a single escalation by ID