Syntax of the alarm filter (RT Unified) - WinCC Unified

WinCC Unified Open Pipe (RT Unified)
ft:publication_title
WinCC Unified Open Pipe (RT Unified)
Product
WinCC Unified
Version
V20
Publication date
06/2025
Language
en-US
Syntax of the alarm filter

With an AlarmSubscription, a filter can be transferred so that not all active alarms of the alarm system are notified, but only those which match the filter. The filter syntax is based on SQL syntax. However, only the WHERE instruction is relevant. The keyword "WHERE" must be omitted.

Operators

The following operators can be used in the filter string of the alarm filter:

Operator

Description

Example

=

equal to

Name = 'Recipe246'

<>

not equal

Value <> 0.0

>

greater than

Value > 25.0

<

less than

Value < 75.0

>=

greater than or equal to

Value >= 25.0

<=

less than or equal to

Value <= 75.0

OR, ||

logical OR

State = 1 OR State = 3

AND, &&

logical AND

Value >= 25.0 AND Value <= 75.0

BETWEEN

within a range

Value BETWEEN 25.0 AND 75.0

NOT BETWEEN

outside a range

Value NOT BETWEEN 25.0 AND 75.0

LIKE string

corresponds to the string string

Name LIKE 'Motor*'

NOT LIKE string

does not correspond to the string string

Name NOT LIKE 'Valve*'

IN (v1, v2, …)

corresponds to one or more values

State IN (1, 4, 7)

NOT IN (v1, v2, …)

does not correspond to one or more values

State NOT IN (0, 2, 3, 5, 6)

(…)

brackets expressions

Value <= 75.0 AND (State = 1 OR State = 3)

Precedence of the operators:

Rank

Operators

1

  • Relational operators:

    =, <>, >, <, >=, <=

  • LIKE

  • IN

  • BETWEEN

2

NOT

3

AND, &&

4

OR, ||

Permitted wildcards:

Wildcard

Description

Example

*

Replaces 0 to more characters

Name LIKE ‘Motor*’

Reference = <1.*.15>1

?

Replaces 1 character

Name = ‘Recipe?’