DSC_ALMLISTFILTERCOND table

Unique number of the descriptor.

The number of this filter (0-based).

The number of this condition (0-based). A maximum of 10 conditions can be defined on each filter.

1 if the relation is a boolean AND with the other relations, 2 if the relation is a boolean OR. Note that AND has higher precedence than OR.

A number specifying the variable to filter on:

0 = Ack date and time
1 = Begin date and time
2 = End date and time
3 = Worst value
4 = Priority
5 = Alarm number
6 = Value
7 = Driver
8 = Node number
9 = Object name
10 = Object description
11 = Area name
12 = Alarm text
13 = Alarm state
14 = User

The type of the variable:

1 = String (VARIABLE = 9-14)
3 = Date (VARIABLE = 0-2)
4 = Value (VARIABLE = 3-8)

The type of relation used:

For string (TYPE = 1)
0 = begins with
1 = is exactly

For dates (TYPE = 3):
0 = on
1 = between
2 = yesterday
3 = today
4 = in the last

For values (TYPE = 4)
0 = greater than
1 = less than
2 = equal to
3 = not equal to
4 = is between

The string to compare with. Only used when TYPE = 1, NULL otherwise.

The date to compare with. Only used when TYPE = 3 and RELATION is 0 or 1, NULL otherwise.

The end date for a date interval, only used when TYPE = 3 and RELATION = 1, NULL otherwise.

Value to compare with. Only used when TYPE = 4, or TYPE = 3 and RELATION = 4 (to specify a number of days), NULL otherwise.

The end value for an interval, only used when TYPE = 4 and RELATION = 4, NULL otherwise.