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

QueryLookup Method—Sets or Retrieves a Query that Fetches Objects

The QueryLookup method sets or retrieves a query that fetches objects based on a property specified in a group table.

Syntax

The QueryLookup method has the following format:

Netegrity::PolicyMgtODBCQueryScheme‑>QueryLookup([queryLookup])

Parameters

The QueryLookup method accepts the following parameter:

queryLookup (string)

(Optional) Specifies the query that fetches the objects.

Return Value

The QueryLookup 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 Name %s Union select Name, 'Group' as Class from SmGroup where Name %s order by Class