Programming Guides › Programming Guide for Perl › CLI Policy Management Methods › ODBC Query Scheme Methods › QueryGetGroups Method—Sets or Retrieves a Query that Fetches the Names of the Groups that the User Is a Member of

QueryGetGroups Method—Sets or Retrieves a Query that Fetches the Names of the Groups that the User Is a Member of

The QueryGetGroups method sets or retrieves a query that fetches the names of the groups that the user is a member of.

Syntax

The QueryGetGroups method has the following format:

Netegrity::PolicyMgtODBCQueryScheme‑>QueryGetGroups([queryGetGroups])

Parameters

The QueryGetGroups method accepts the following parameters:

queryGetGroups (string)

(Optional) Specifies the query that fetches the names of the user's groups.

Return Value

The QueryGetGroups method returns one of the following values:

• The new or existing query
• undef if the call is unsuccessful

Remarks

Sample query (based on the SiteMinder sample database schema SmSampleUsers). The %s expression is a placeholder for a user name parameter to be supplied by SiteMinder when the query is executed:

select SmGroup.Name from SmGroup, SmUser, SmUserGroup where SmUser.Name = '%s' and SmUser.UserId = SmUserGroup.UserId and SmGroup.GroupId = SmUserGroup.GroupId