ISQLFilterCondition

class ISQLFilterCondition

Bases: ImpactCOMWrapperBase

Description:

Defines a condition which must be met when searching for certain database items (such as layers).

Remarks:

Introduced in Impact 7.0.0.34

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

property allow_nulls

Gets allow_nulls.

Description:

Specifies whether null values are to be included in the results.

Remarks:

Introduced in Impact 12.0.0.149

Returns:

The value of allow_nulls.

Return type:

allow_nulls (bool)

property brackets_after

Gets brackets_after.

Description:

The number of parentheses to be added after the condition.

Remarks:

Introduced in Impact 12.0.0.149

Returns:

The value of brackets_after.

Return type:

brackets_after (int)

property brackets_before

Gets brackets_before.

Description:

The number of parentheses to be added before the condition.

Remarks:

Introduced in Impact 12.0.0.149

Returns:

The value of brackets_before.

Return type:

brackets_before (int)

property column

Gets Column.

Description:

The name of the column whose value must meet the condition.

Returns:

The value of Column.

Return type:

column (str)

property group_id

Gets group_id.

Description:

Specifies a group into which the condition will be placed.

Remarks:

Introduced in Impact 9.0.0.31

Returns:

The value of group_id.

Return type:

group_id (int)

property logical_operator

Gets logical_operator.

Description:

Specifies how the condition is to be combined with all the other conditions (AND or OR).

Remarks:

Introduced in Impact 12.0.0.149

Returns:

The value of logical_operator.

Return type:

logical_operator (str)

property match_case

Gets match_case.

Description:

Specifies if the search will be case sensitive.

Returns:

The value of match_case.

Return type:

match_case (bool)

property match_case_known

Gets match_case_known.

Description:

Leave this as false to specify that case matching should be determined internally (hence ignoring match_case)

Remarks:

For legacy systems that don’t specify match_case, this will be false, and case matching will be determined internally.

Returns:

The value of match_case_known.

Return type:

match_case_known (bool)

property operator

Gets Operator.

Description:

The way in which the values should be compared. Currently supported operators are: = > >= <> like between not like not between This string is case-insensitive.

Returns:

The value of Operator.

Return type:

operator (str)

property string_search_type

Gets string_search_type.

Description:

When searching on string data, this specifies what type of search to perform.

Returns:

The value of string_search_type.

Return type:

string_search_type (ipStringSearchType)

property values

Gets Values.

Description:

The value(s) against which the column value is to be compared.

Returns:

The value of Values.

Return type:

values (any)

Examples