SentryOne Test Web Portal Notification Subscription Filters

SentryOne Test Subscription Filters

You can add filter expressions to SentryOne Test Subscriptions on the Create Subscription page.

SentryOne Test Create Subscription Filters

Hide subscription filters by selecting the Hide Filters button. 

SentryOne Test Create Subscription Filters hiddenFilters Hidden

Selecting theSentryOne Test Lightbulb buttonbutton displays the following explanation of Filters in SentryOne Test :

Filter Expressions

Filter expressions are very similar to SQL WHERE clauses. You can enter text that refers to column names and uses operators to compare with other columns or static values. Filter expressions also support combinational logic using AND/OR.

Samples

[Size] > 50000
[DateModified] BETWEEN '2017/01/01' AND '2017/02/01'
[CustomerName] LIKE 'Fred%' AND [OrderComplete] != 1

Available Operators

Filter OperatorDescription
=Equals
!=Not Equal
<>Not Equal
>Greater Than
>=Greater Than Or Equal To
<Less Than
<=Less Than Or Equal To
!>Not Greater Than
!<Not Less Than
LIKEValue matches SQL-style string pattern
NOT LIKEValue does not match SQL-style string pattern
BETWEENValue falls between [x] and [y]
NOT BETWEENValue does not fall between [x] and [y]
IS NULLValue is null
IS NOT NULLValue is not null

Combinational Operators

AND/OR can be used to combine expression clauses, and parenthesis can be used to group clauses.

[a] = 5 AND [b] = 2 AND [c] = 9
[a] > 1 AND ([b] > 10 OR [c] > 20)

Static value formatting

Values are formatted as they would be in SQL. Strings, GUIDs and Date/Time values are enclosed in quotes, Boolean values are 0 or 1 and numeric values are represented naturally.

ValueExample
String
'a string'
GUID
'6264E1FD-D1DA-49B2-977E-5BAD05BCAC9D'
Date/Time
'2017/03/01'
Boolean
1
Integer
16107
Float
753.452