Database query

Vamsi Kandala

Hi all,

This is related to PostgreSQL query question:

I am using the following query to fetch all the Confluence spaces which has the specified group having permissions.

SELECT distinct s.spacekey, s.spacename
FROM SPACEPERMISSIONS sp
JOIN SPACES s ON s.SPACEID = sp.SPACEID
JOIN cwd_group g ON sp.PERMGROUPNAME = g.group_name
JOIN cwd_membership m ON g.id = m.parent_id
WHERE sp.permgroupname = '<group name>'
GROUP BY s.spacekey, s.spacename
ORDER BY s.spacename

This is working fine.  I want to extend this query further and retrieve all the space admins for each of the above spaces separated by comma in another column.

Any help is appreciated.

Thanks,
Vamsi

Tommy Augustine_u4x60v

I don't have jira server, so I cannot play with this to help out. But it sounds like you need to embed another query within the third column that concatenates the result set of space admins for a given space name in the where clause.

That's the best I can answer without playing with the query.