1 person found this helpful
Constructing that query will be difficult, but this page should help with the high-level structure.
Some key points to focus in a bit:
- Spaces are ObjectType, if you hardcode that as an object-type, you can bind results directly to the jivecommunity table ... all Object IDs from jiveCommunity will match Object IDs in other tables if the ObjectType locked to 14.
- Other tables you'll need : jiveCommunity, jiveEntitlement*, jiveperm*, jiveUser, jiveGroup, jiveGroupUser
As for the API, it is straight forward to check the Applied Entitlements using:
All you have to do is resolve the SecurityGroups and User references. It's a bit more traversing API calls, but it will definitely be a lot easier IMO.
Hope that helps.
I'm getting more security groups than i probably want. In the Jive UI for the space, I have a section labeled "SPACE ADMINISTRATORS:" with 10 people. When I query for unique appliedEntitlements for the space, I get 5 groups with thousands of users. I see 2 of those groups is what I need but dont see what logic can be applied to exclude the other 3 groups. I don't see how to filter for only "Administer" level permission.