Method ListProtectionEventsByMessage

internal/identity/screening.go:88–102

ListProtectionEventsByMessage returns every screening event recorded against a message, newest first — the breakdown a reviewer sees for a held item.

(ctx context.Context, messageID string)

// ListProtectionEventsByMessage returns every screening event recorded against a
// message, newest first — the breakdown a reviewer sees for a held item.
func (s *Store) ListProtectionEventsByMessage(ctx context.Context, messageID string) ([]ProtectionEvent, error) {
	rows, err := s.pool.Query(ctx,
		`SELECT id, message_id, agent_id, direction, source, reason, action,
		        subject_addr, detector, score, categories, spans, raw, created_at
		   FROM protection_events
		  WHERE message_id = $1
		  ORDER BY created_at DESC, id`,
		messageID,
	)
	if err != nil {
		return nil, fmt.Errorf("list screening events by message: %w", err)
	}
	defer rows.Close()
	return scanProtectionEvents(rows)
}

// ListProtectionEventsByAgent returns an agent's most recent screening events
// (newest first, capped by limit) for the security/analytics view.