diff options
Diffstat (limited to 'forged/sql/queries')
| -rw-r--r-- | forged/sql/queries/groups.sql | 3 |
1 files changed, 3 insertions, 0 deletions
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 |