Skip to Content.
Sympa Menu

grouper-users - [grouper-users] RE: Grouper 2.4 WS Query Child Groups / Users

Subject: Grouper Users - Open Discussion List

List archive

[grouper-users] RE: Grouper 2.4 WS Query Child Groups / Users

Chronological Thread 
  • From: "Hyzer, Chris" <>
  • To: Reid Watson <>, Grouper-Users <>
  • Subject: [grouper-users] RE: Grouper 2.4 WS Query Child Groups / Users
  • Date: Mon, 3 Dec 2018 01:51:37 +0000
  • Accept-language: en-US
  • Authentication-results: spf=none (sender IP is ) ;
  • Ironport-phdr: 9a23:EguKAxFh1WyVwbenhbPCIJ1GYnF86YWxBRYc798ds5kLTJ76p8i9bnLW6fgltlLVR4KTs6sC17KG9fi4EUU7or+5+EgYd5JNUxJXwe43pCcHRPC/NEvgMfTxZDY7FskRHHVs/nW8LFQHUJ2mPw6arXK99yMdFQviPgRpOOv1BpTSj8Oq3Oyu5pHfeQpFiCa+bL9oMBm6sRjau9ULj4dlNqs/0AbCrGFSe+RRy2NoJFaTkAj568yt4pNt8Dletuw4+cJYXqr0Y6o3TbpDDDQ7KG81/9HktQPCTQSU+HQRVHgdnwdSDAjE6BH6WYrxsjf/u+Fg1iSWIdH6QLYpUjm58axlVAHnhzsGNz4h8WHYlMpwjL5AoBm8oxBz2pPYbJ2JOPZ7eK7WYNEUSndbXstJVyJPHJ6yb5cBAeQCM+ZXrYj9qEcBoxSxHgSsGPjgxiNUinPqwaE30eIsGhzG0gw6GNIOtWzZoNv3OqYSUOG60rPIwS3eZP5I2Tf98onIcgsvrfqRWr9wdNbeyUkvFgLEkFqQs5foPzKO1usRqWSb8vJgWvypi24hsQ1+vCWgxto1h4TPm4kbxFfE9SBjz4Y0I921UFR0YcO4H5tTsyGVLY12Td44T25ypCk3zKANt52jfCUS1pgo3QLTZ+GCfoSV/x7vSeOcITl3iX55ZL6yghS//lavx+D8U8S51UhGojZbntXUq3wA2QDf5tKDR/dg5EutxyuD2gTJ5u1ZI005lLLXK5A/zbMzipYetEHOEyH5lUrql6Cbc14r9va05+v7Z7jrpIGQO5Fohgz7L6gjms6yDv8+PwMTRWaU4/6826fm/UDhQLVFkPk2kq7BvZ7COckVobK1DxFM3os96RmzEi6q0NMDknYZNl5Ffw+Hj5TyNFHJPfD4C+qwj060kDdxwPDGIqPuDYnRLnjCl7fhe6xx60lByAovydBf4JVUCrIbLP3vXU/xscTUDh4/MwOq3+bqEMtx2ZkCVW6SB6KVLb7evUKN6+IhLOSAeJMZtTP/Jvc76PPjjXo0lFoDcaW1w5cbcHW4Ee5nI0Wdb3rsmNABEWISswo7UOPqiF2DUD9NaHaoRK885yo7B568AYfeXoCinrqB3CGhEpJIe29GF0iAEW30eIWcR/cMdCWSL9dukjweUrihVpch2g+0tAPj1rpnNfTb+jcDtZ/40Nh15vbTlQ0p9TBqFcid0meNT31qkWMSQT85wrx/rVJnxlidzKd4nq8QKdsG3f5IXk8FPILHyOoyX8r/Ww6HYd6VU1Ggaty7CjI1R9Q9hdYFJUBvTZHqoQrEwjKnGfoojLGRH9Rg/bjbwmD8PYNg0Hvcz4EgiUUrWM1CKTfgi6JioVv9HYnMxg+5hrSnb+BU9y7X9XzJhT6Lt0FJQgNqeaTeVjYCfkbQq5L06l6UHOzmMqguLgYUkZ3KEaBNcNC8yAweHK25at3Df2K8nXuxDh+Ux7SKKZDnYHgZwD6DVBofiw5G+3GAOEB+HSqnr2/ERB1WXVP0KwKJk6FlrW+jCEo9zgWEdUpkgr+++g8HiOa0SugYmK8ctSEn7Th4AQX10g==
  • Spamdiagnosticmetadata: NSPM
  • Spamdiagnosticoutput: 1:99

I don’t understand what you mean when you say the lite membership doesn’t
support pagination. It looks like it does to me.

In any case, you should filter on subject source id(s).

g:gsa will return you groups.
Whatever person subject source(s) you have configured will return people.



-----Original Message-----

On Behalf Of Reid Watson
Sent: Tuesday, November 20, 2018 8:04 PM
To: Grouper-Users
Subject: [grouper-users] Grouper 2.4 WS Query Child Groups / Users

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

"includeGroupDetail": "F",
"includeSubjectDetail": "T",
"memberFilter": "Immediate",
"pageNumber": "1"

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

"includeGroupDetail": "F",
"includeSubjectDetail": "T",
"memberFilter": "Immediate",
"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 owner_group, child_group
from grouper_groups gg1, grouper_groups gg2, grouper_memberships gm,
grouper_members ggs
where gm.owner_group_id =
and = ''
and ggs.subject_id =
and gm.member_id =
--and gm.mship_type = ‘immediate’;

-- get all group users with pagination
select groupName, ggs.subject_id personid, ggs.subject_identifier0
upi, ggs.description name
from grouper_groups gg, grouper_members ggs, grouper_memberships gm
where = ''
and gm.owner_group_id =
and gm.member_id =
and ggs.subject_type = 'person'
order by ggs.subject_id -- sorting by personid

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



  • [grouper-users] RE: Grouper 2.4 WS Query Child Groups / Users, Hyzer, Chris, 12/03/2018

Archive powered by MHonArc 2.6.19.

Top of Page