ILookupParameters

class ILookupParameters

Bases: ImpactCOMWrapperBase

Summary:

Parameters to be used when making a database lookup.

Remarks:

Introduced in Impact 11.0.0.48.

Wraps a COM object or another wrapper instance. Accepts: - A valid impact_object - An existing impact_com_wrapper_base-derived instance

property display_column

Gets display_column.

Summary:

Specifies the column in the specified table to read values from.

Returns:

The value of display_column.

Return type:

display_column (str)

property filter_sql

Gets filter_sql.

Summary:

Optionally specifies SQL to filter the results.

Remarks:

For example , “CS_ACTIVE = 1”.

Returns:

The value of filter_sql.

Return type:

filter_sql (str)

property known_key

Gets known_key.

Summary:

Key of row that must be included.

Remarks:

There are situations where you may need include the row for a specific key, even if the filter_sql or now row’s active status would otherwise exclude it. This might be necessary to display a look-ups “current value” which may no longer be a natural part of the lookup row set. known_key promotes selection of the desired row ensuring it is always included. See also the known_key_exclusive property.

Returns:

The value of known_key.

Return type:

known_key (int)

property known_key_exclusive

Gets known_key_exclusive.

Summary:

Indicates whether to return only the row given by the known_key value.

Remarks:

This flag supplements know_key to restrict the selection to this single row, which results in simpler and more efficient SQL.

Returns:

The value of known_key_exclusive.

Return type:

known_key_exclusive (bool)

property order_by_sql

Gets order_by_sql.

Summary:

Optionally specifies how the results should be sorted.

Remarks:

Note that the “order by” keywords should not be included in this string.

Returns:

The value of order_by_sql.

Return type:

order_by_sql (str)

property relationships

Gets Relationships.

Summary:

A string representing one or more database table relationsahips.

Remarks:

Multiple relationships should be separated using a semicolon “;”

Returns:

The value of Relationships.

Return type:

relationships (str)

property respect_active_flags

Gets respect_active_flags.

Summary:

Indicates whether the active flag should be used to filter the rows.

Remarks:

The active/archived flag is optionally defined for the table. Sometimes you may wish to generate lookup results that include inactive/archived values.

Returns:

The value of respect_active_flags.

Return type:

respect_active_flags (bool)

property table_name

Gets table_name.

Summary:

Specifies the name of the table to read values from.

Returns:

The value of table_name.

Return type:

table_name (str)

isNone()

Checks if the COM object is None. This is useful for determining if the wrapper has been initialized with a valid COM object.