Date: Thu, 28 Mar 2024 19:31:22 +0000 (UTC) Message-ID: <436774795.6867.1711654282750@ip-10-10-7-29.ec2.internal> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_6866_1083240324.1711654282747" ------=_Part_6866_1083240324.1711654282747 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html
For Grouper 2.6 and above, please see this page for SQL provisioning.
In more advanced/complex use case you may find it useful to use SQL to e=
xplore the Grouper data and or to achieve very complex tasks. This page is =
a Catch All page for things that SQL can be used to do. Expand as needed
You might find it useful to use an SQL loader job that could create grou= ps of groups or other kinds of constructs based on the Grouper Attribute Fr= amework. This kind of a construct can let you use attributes to drive how a= nd what the Loader job does and is really only limited by your SQL knowledg= e and your imagination for how to use the Attribute Framework.
As a simple example: Let's say that you create an attribute =
( etc:local:DepartmentXGroup ) that you allow "normal grouper users" to ass=
ign to a group that should be considered "lists of people in Department X".=
And you want to maintain a reference group "ref:All_Departments:Department=
X" that should have all groups that are "marked" with the "DepartmentXGroup=
".
You can use an SQL statement like the following ( example MYSQL,)
select group_name From grouper_attr_asn_group_v where enabled =3D '= T' and attribute_def_name_name =3D 'etc:local:DepartmentXGroup'
This example clearly does not scale well. You would need to create SQL load=
er jobs per attributeName (AKA: "Department Marker" ). However, it could be=
expanded to looking for a set of markers that could also "group by" the&nb=
sp;attribute_def_name_name or use other SQL constructs to create the groupN=
ame value for the SQL Loader job. too. ( Again, only limited by your =
S:QL knowledge and imagination.