FilterItems Table

Applies to QAComplete 12.70 SaaS, last modified on January 11, 2021

Description

The table contains filter items. A filter consists of a set of filter items with the same FilterID. The Seq column shows the order of the items within the filter. Each filter item is a conditional statement that is linked to the next filter item and may contain a different number of opening and closing parenthesis.

Columns

The table contains the following columns:

FilterId  :  int, primary key, allows null: no

The unique identifier of the filter.

Seq  :  int, primary key, allows null: no

The sequential number of the filter item among the items with the same FilterId.

AltXEntitySQL  :  varchar (max 1000 chars), allows null: yes

The column is reserved for system use only.

AltXEntitySQLCondition  :  varchar (max 200 chars), allows null: yes

The column is reserved for system use only.

AndOr  :  varchar (max 3 chars), allows null: yes

The operator that is used to link the filter item to the next item.

Caption  :  varchar (max 100 chars), allows null: no

The caption of the filter item.

Condition  :  varchar (max 20 chars), allows null: no

The comparison operation that the filter item uses to compare values.

FieldName  :  varchar (max 100 chars), allows null: no

The name of the field whose value is compared.

ParenthesisBegin  :  varchar (max 10 chars), allows null: yes

The opening parenthesis before the item.

ParenthesisEnd  :  varchar (max 10 chars), allows null: yes

The closing parenthesis after the item.

Value  :  varchar (max 1000 chars), allows null: no

The value to be compared with the field’s value.

See Also

Filters Table
Crossmodules

Highlight search results