Function handleExceptionsGrouped

modules/sentry/api_exceptions.go:24–122

(db *sql.DB, w http.ResponseWriter, r *http.Request)

}

func handleExceptionsGrouped(db *sql.DB, w http.ResponseWriter, r *http.Request) {
	limit, offset := pagination(r, 50)
	q := r.URL.Query()

	query := `SELECT
		g.fingerprint,
		se.exception_type,
		se.exception_value,
		g.count,
		g.first_seen,
		g.last_seen,
		g.level,
		g.handled,
		g.sample_event_id
	FROM (
		SELECT
			e.fingerprint,
			COUNT(*) as count,
			MIN(e.received_at) as first_seen,
			MAX(e.received_at) as last_seen,
			MAX(e.level) as level,
			MIN(e.handled) as handled,
			MAX(e.event_id) as sample_event_id
		FROM sentry_error_events e`

	countQuery := `SELECT COUNT(DISTINCT e.fingerprint) FROM sentry_error_events e`

	var conditions []string
	var args []any

	if v := q.Get("level"); v != "" {
		conditions = append(conditions, "e.level = ?")
		args = append(args, v)
	}
	if v := q.Get("handled"); v != "" {
		if v == "true" {
			conditions = append(conditions, "e.handled = 1")
		} else {
			conditions = append(conditions, "e.handled = 0")
		}
	}

	where := ""
	if len(conditions) > 0 {
		where = " WHERE " + strings.Join(conditions, " AND ")
	}

	query += where + ` GROUP BY e.fingerprint
	) g
	LEFT JOIN sentry_error_events sample_e ON sample_e.event_id = g.sample_event_id
	LEFT JOIN sentry_exceptions se ON se.error_event_id = sample_e.id AND se.position = 0
	ORDER BY g.count DESC LIMIT ? OFFSET ?`
	countQuery += where

	// Get total.
	var total int
	db.QueryRow(countQuery, args...).Scan(&total)