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.