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]

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.