Различия

Здесь показаны различия между двумя версиями данной страницы.

--- howto:services:confluence [2023/02/01 11:37]
Алексей Кожевников создано
+++ howto:services:confluence [2023/02/01 11:49] (текущий)
Алексей Кожевников
@@ Строка 6: / Строка 6: @@
        s.SPACEKEY,
        sg.groups,
-       GROUP_CONCAT(distinct um.lower_username ORDER BY um.lower_username SEPARATOR ', ') as users
+       GROUP_CONCAT(distinct cu.display_name ORDER BY cu.display_name SEPARATOR ', ') as users
 FROM confluence.SPACEPERMISSIONS sp
 JOIN confluence.SPACES s ON s.SPACEID = sp.SPACEID
-JOIN confluence.user_mapping um ON um.user_key = sp.PERMUSERNAME
+LEFT OUTER JOIN confluence.user_mapping um ON um.user_key = sp.PERMUSERNAME
-JOIN (select s.SPACEID,
+LEFT OUTER JOIN confluence.cwd_user cu ON um.username = cu.user_name
-             GROUP_CONCAT(distinct sp.PERMGROUPNAME ORDER BY sp.PERMGROUPNAME SEPARATOR ', ') as groups
+LEFT OUTER JOIN (select s.SPACEID, GROUP_CONCAT(distinct sp.PERMGROUPNAME ORDER BY sp.PERMGROUPNAME SEPARATOR ', ') as groups
 	FROM confluence.SPACEPERMISSIONS sp
 	JOIN confluence.SPACES s ON s.SPACEID = sp.SPACEID

Wiki