ZhAgent/apps/tools/sql/list_tool_user.sql

SELECT *
FROM (SELECT tool."id"::text,
             tool."name",
             tool."desc",
             tool."tool_type",
             tool."scope",
             'tool'           AS "resource_type",
             tool."workspace_id",
             tool."folder_id",
             tool."user_id",
             "user".nick_name AS "nick_name",
             tool."icon",
             tool.label,
             tool."template_id"::text,
             tool."create_time",
             tool."update_time",
             tool.init_field_list,
             tool.input_field_list,
             tool.version,
             tool."is_active"
      FROM (SELECT tool.*
            FROM tool tool ${tool_query_set}
             AND tool.id::text IN (SELECT target
                          FROM workspace_user_resource_permission
                          ${workspace_user_resource_permission_query_set}
                            AND 'VIEW' = ANY (permission_list))) AS tool
               LEFT JOIN "user" ON "user".id = user_id
) temp
      ${default_query_set}