EOL: SentryOne Test reached its end of life date on June 15, 2022. See the Solarwinds End of Life Policy for more information.
SentryOne Test Subscription Filters
You can add filter expressions to SentryOne Test Subscriptions on the Create Subscription page.
Hide subscription filters by selecting the Hide Filters button.
Filters Hidden
Selecting the
button 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] != 1Available Operators
| Filter Operator | Description |
|---|---|
| = | 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 |
| LIKE | Value matches SQL-style string pattern |
| NOT LIKE | Value does not match SQL-style string pattern |
| BETWEEN | Value falls between [x] and [y] |
| NOT BETWEEN | Value does not fall between [x] and [y] |
| IS NULL | Value is null |
| IS NOT NULL | Value 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.
| Value | Example |
|---|---|
| String | 'a string' |
| GUID | '6264E1FD-D1DA-49B2-977E-5BAD05BCAC9D' |
| Date/Time | '2017/03/01' |
| Boolean | 1 |
| Integer | 16107 |
| Float | 753.452 |
