Grouper Developers Forum

[Chris Hyzer <>]

I pictured that would happen with another loader managed query.  E.g. the org 
query is like this:

Group_name                          subject_id
school.orgs.org123_systemOfRecord   12345
school.orgs.org123_systemOfRecord   12346
school.orgs.org124_systemOfRecord   12347

Then you would have another grouper loader query which would do the rollups.  
It's a little complicated since the subject_id of a group is its UUID, so we 
need to pack it in somehow...  note the subject_id group name is the 
"overall" group, not the system of record one...

Group_name                                    subject_id
school.orgs.org123AndSubOrgs_systemOfRecord   group_name__school.orgs.org123
school.orgs.org123AndSubOrgs_systemOfRecord   group_name__school.orgs.org124
school.orgs.org126AndSubOrgs_systemOfRecord   group_name__school.orgs.org126
school.orgs.org126AndSubOrgs_systemOfRecord   group_name__school.orgs.org127

Otherwise how would the loader know the org hierarchy?  Is this ok?

Thanks,
Chris


> -----Original Message-----
> From: Tom Barton 
> [mailto:]
> Sent: Friday, October 24, 2008 10:41 AM
> To: Loris Bennett
> Cc: Chris Hyzer; Grouper Dev
> Subject: Re: [grouper-dev] auto-creating "include" and "exclude" groups
> based on group type hook
>
> Loris Bennett wrote:
> > I mentioned the idea of having a "orgAll" and "orgRecursiveAll" to
> > distinguish between the group all the members associated with a
> > particular org unit and the group of members associated with a
> > particular org unit or one of its descendants.
> >
> > Could this also be realized in this context.
>
> Good point. In fact, U Chicago wrote a java util to create an org
> hierarchy in grouper from an SoR source with include, exclude, and
> rollup groups, exactly as you describe. So "+1" to your feature
> request.
>
> Tom