-
Re: user access to a specific space
gregor.honer Oct 28, 2016 6:39 AM (in response to hhaeffner)Hey Heinrich,
Have you seen this question SQL query for seeing who has viewed a space? ?
Would that help?
Maybe not 100% what you are after but should not be that hard to adapt
-
Re: user access to a specific space
hhaeffner Oct 28, 2016 7:10 AM (in response to gregor.honer)Hi Gregor,
unfortunately not.
I want to query the users which have access to a specific space.
Thanks
Heinrich
-
Re: user access to a specific space
gregor.honer Oct 31, 2016 12:50 AM (in response to hhaeffner)Ok let me look into this once again and see if I can help.
-
-
-
Re: user access to a specific space
gregor.honer Nov 14, 2016 5:52 AM (in response to hhaeffner)Hey Heinrich,
Could you try this?
SELECT * FROM jiveentitlement WHERE objecttype = 14 and objectid = <spaceid> AND (userid = <userid> OR groupid IN (SELECT groupid FROM jivegroupuser WHERE userid = <userid>))
We dont have space members in the same way as social group members, we determine access based on entitlements and the above query will return all users or usergroups that have an entitlement on a given space.
Thanks
-Gregor