From f7dde29539536a67687cbeff9662a9617e077150 Mon Sep 17 00:00:00 2001 From: Runxi Yu Date: Mon, 18 Aug 2025 03:12:41 +0800 Subject: Make the index page work --- forged/sql/queries/groups.sql | 3 +++ 1 file changed, 3 insertions(+) (limited to 'forged/sql/queries') diff --git a/forged/sql/queries/groups.sql b/forged/sql/queries/groups.sql index 07fe5e7..5b48fc4 100644 --- a/forged/sql/queries/groups.sql +++ b/forged/sql/queries/groups.sql @@ -1,3 +1,6 @@ +-- name: GetRootGroups :many +SELECT name, COALESCE(description, '') FROM groups WHERE parent_group IS NULL; + -- name: GetGroupIDDescByPath :one WITH RECURSIVE group_path_cte AS ( SELECT -- cgit v1.2.3