ZhAgent/apps/application/sql/list_application_user_ee.sql

select *
from (select application."id"::text, application."name",
             application."desc",
             application."is_publish",
             application."type",
             'application'      as "resource_type",
             application."workspace_id",
             application."folder_id",
             application."user_id",
             "user"."nick_name" as "nick_name",
             application."create_time",
             application."update_time",
             application."publish_time",
             application.icon
      from application
               left join "user" on user_id = "user".id
      where "application".id::text in (select target
                                 from workspace_user_resource_permission ${workspace_user_resource_permission_query_set}
        and case
                when auth_type = 'ROLE' then
                    'ROLE' = any (permission_list)
                        and
                    'APPLICATION:READ' in (select (case
                                                       when user_role_relation.role_id = any (array['USER'])
                                                           THEN 'APPLICATION:READ'
                                                       else role_permission.permission_id END)
                                           from role_permission role_permission
                                                    right join user_role_relation user_role_relation
                                                               on user_role_relation.role_id = role_permission.role_id
                                           where user_role_relation.user_id = workspace_user_resource_permission.user_id
                                             and user_role_relation.workspace_id =
                                                 workspace_user_resource_permission.workspace_id)

                else
                    'VIEW' = any (permission_list)
          end)) temp
${application_query_set}