Programming Guides › Programming Guide for Perl › CLI Policy Management Methods › ODBC Query Scheme Methods › QueryLookupUser Method—Sets or Retrieves a Query that Fetches a User Name

QueryLookupUser Method—Sets or Retrieves a Query that Fetches a User Name

The QueryLookupUser method sets or retrieves a query that fetches a user name based on a property specified in the user table.

Syntax

The QueryLookupUser method has the following format:

Netegrity::PolicyMgtODBCQueryScheme‑>QueryLookupUser([queryLookupUsr])

Parameters

The QueryLookupUser method accepts the following parameter:

queryLookupUsr (string)

(Optional) Specifies the query that fetches the user name.

Return Value

The QueryLookupUser 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 parameter to be supplied by SiteMinder when the query is executed:

select Name, 'User' as Class from SmUser where %s