From 8ed0dbe4201a58b00d6f3743178f4cbe5328e2b0 Mon Sep 17 00:00:00 2001 From: Runxi Yu Date: Thu, 6 Mar 2025 15:17:57 +0800 Subject: *: Support subgroups via SQL recursion --- http_handle_index.go | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'http_handle_index.go') diff --git a/http_handle_index.go b/http_handle_index.go index f710315..4632526 100644 --- a/http_handle_index.go +++ b/http_handle_index.go @@ -11,7 +11,7 @@ func handle_index(w http.ResponseWriter, r *http.Request, params map[string]any) var err error var groups []name_desc_t - groups, err = query_name_desc_list(r.Context(), "SELECT name, COALESCE(description, '') FROM groups") + groups, err = query_name_desc_list(r.Context(), "SELECT name, COALESCE(description, '') FROM groups WHERE parent_group IS NULL") if err != nil { http.Error(w, "Error querying groups: "+err.Error(), http.StatusInternalServerError) return -- cgit v1.2.3