Grouper Users - Open Discussion List

[Reid Watson <>]

Hi Everyone, 

We have been working with Grouper WS for the last two months and come across 
a couple of issues that we wanted your advice on.  

Currently our requirements is to get child groups or users from a group, but 
grouper services seem not to provide the functionality to filter.

1. Lite services don’t support pagination. (Maybe by desgin)
2. Member json service support pagination, but not sure how to filter with 
subgroups or users

Example Request 

{
  "WsRestGetMembersRequest":{
    "wsGroupLookups":[
      {
        "groupName":"psrwi.auckland.ac.nz:Employee"
      }
    ],
    "includeGroupDetail": "F",
    "includeSubjectDetail": "T",
    "memberFilter": "Immediate",
    "pageSize":"10",
    "pageNumber": "1"
  }
} 

3. Membership service doesn’t support pagination, it seems to be ignored 

{
  "WsRestGetMembershipsRequest":{
    "wsGroupLookups":[
      {
        "groupName":"psrwi.auckland.ac.nz:Employee"
      }
    ],
    "includeGroupDetail": "F",
    "includeSubjectDetail": "T",
    "memberFilter": "Immediate",
    "pageSize":"10",
    "pageNumber": "1"
  }
}
 
Were thinking about customising Grouper WS / Create SP or View within the DB 
to support our specific needs “get child groups or users from a group", there 
are concerns when we upgrade but for example  

-- get all child groups
select gg1.name owner_group, gg2.name child_group
from grouper_groups gg1, grouper_groups gg2, grouper_memberships gm, 
grouper_members ggs
where gm.owner_group_id = gg1.id
and gg1.name = 'ec.auckland.ac.nz:ecusers'
and ggs.subject_id = gg2.id
and gm.member_id = ggs.id
--and gm.mship_type = ‘immediate’;

-- get all group users with pagination
select gg.name groupName, ggs.subject_id personid, ggs.subject_identifier0 
upi, ggs.description name
from grouper_groups gg, grouper_members ggs, grouper_memberships gm
where gg.name = 'psrwi.auckland.ac.nz:Employee'
and gm.owner_group_id = gg.id
and gm.member_id = ggs.id
and ggs.subject_type = 'person' 
order by ggs.subject_id -- sorting by personid
OFFSET 10 ROWS FETCH NEXT 10 ROWS ONLY; -- from 10~20


It seems to make our life easier and limit the number of calls to WS we need 
to write our own queries and customise GrouperWS, If anyone has some advice 
or come across similar issues can you please make some recommendations

cheers

Reid