mirror of
https://github.com/1Panel-dev/MaxKB.git
synced 2025-12-26 01:33:05 +00:00
18 lines
739 B
SQL
18 lines
739 B
SQL
SELECT app_or_knowledge.*,
|
|
COALESCE(workspace_user_resource_permission.permission_list,'{}')::varchar[] as permission_list,
|
|
COALESCE(workspace_user_resource_permission.auth_type,'ROLE') as auth_type
|
|
FROM (SELECT "id",
|
|
"name",
|
|
'APPLICATION' AS "auth_target_type",
|
|
user_id,
|
|
workspace_id,
|
|
icon,
|
|
folder_id
|
|
FROM application
|
|
${query_set}
|
|
) app_or_knowledge
|
|
LEFT JOIN (SELECT *
|
|
FROM workspace_user_resource_permission
|
|
${workspace_user_resource_permission_query_set}) workspace_user_resource_permission
|
|
ON workspace_user_resource_permission.target = app_or_knowledge."id";
|