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.