Grouper Users - Open Discussion List

[Chris Hyzer <>]

 

I would not make a duplicate group that has all the members of students and instructors.

I think you can do what dave is saying, though it should be a loader job, so it will change dynamically as the groups are added/deleted (with “like” string).

 

So you can create a query against peoplesoft that returns group_name (the overall group), and subject_identifier (the group name of the member which is the students group or instructors group).  So basically this will return twice the number of rows as courses that you have.  If you have a dblink and can join to the grouper groups table and get the uuid of the group in a subject_id col that would be quicker, though it is not a requirement.

 

Ok?

 

Thanks,

Chris

 

 

From: [mailto:] On Behalf Of David Langenberg
Sent: Tuesday, February 11, 2014 1:01 PM
To: Bryan E. Wooten
Cc:
Subject: Re: [grouper-users] Designing Groups

 

Use GSH to create a :all group with the :students and :instructors groups as members?

 

Dave

 

On Tue, Feb 11, 2014 at 10:51 AM, Bryan E. Wooten <> wrote:

I’ve run into a mental block in designing my groups.

 

I have created 2 Grouper Loader jobs using SQL_GROUP_LIST. One creates groups for each course section with students as members. The other creates groups for each course section with instructors as members. Both run SQL against our PeopleSoft SIS.

 

I need a group for each course section that includes both instructors and students. I see 2 ways to accomplish this, one I know I can make work.

 

The easiest thing to do would be create a third  SQL_GROUP_LIST using SQL that returns both instructors and students in one query.

 

But I was wondering if I might be better of creating  Grouper Loader job that executes a query against the Grouper DB (GSA) the returns the members of the groups I created above.

 

I didn’t see any way to leverage composite groups to achieve my goal. And I didn’t see a way to leverage include groups either.

 

Any thoughts or opinions invited.

 

-Bryan

 

--
David Langenberg

Identity & Access Management

The University of Chicago