User Guide

Reports
Reports Reference
8
294 | 393
Siemens
User Guide Version 3.0
A6V10415471
Building Technologies
2017-11-30
Condition Filter Syntax
When you are creating a Condition filter, you must know the data type of the
property for which you want to apply the filter. Following are some examples which
will help you create Condition filters without syntax errors.
1. If property displays text data, for example string or enumeration, then the value
must be enclosed within double quotes.
– ‘[Current_Priority]’ = “Priority - 16”
– ‘Object Description’ = “Analog Output 1”
– ‘[Event_State]’ = “Normal”
– '[Present_Value]' = "INACTIVE"
NOTE: The values of some properties such as [Current_Priority] are
referenced in text groups. Therefore, whenever you are assigning values
for such properties, you must refer to the respective text groups. In order to
refer to the text groups in the Management View, you must have an
Engineering license. In the absence of an Engineering license, you will
have to run the report to find out the appropriate values for such properties.
2. If property displays values in the date time format, then the value must be in
date time format configured in Windows on the server. Date must be in the
short date format, time in the long time format (24 hours).
– ‘Main Value’ = 3/13/2014 16:04:25 (assuming that the date format on the
server is M/d/yyyy)
3. If property displays Boolean data, for example. TRUE, FALSE, then the value
must be enclosed in double quotes
– '[Stop_When_Full]' = "True"
– ‘[Log_Enable]’ = “False”
4. If property displays numeric data, for example,. 54.11, 25, -20, then the values
must be specified as follows:
– '[Present_Value]' = 54.11
– '[Present_Value]' >= 25
NOTE: The decimal separator will be according to your Windows Regional
and Language settings.
5. If property displays bit string, then the value must be enclosed by double
quotes
– '[Status_Flags]' <- "Fault"
– ‘[Event_Enable]’ <- “To Fault”
– ‘[Limit_Enable]’ <- “Low Limit Enable”
The Condition filter is applicable only to Objects, Active Events, Activities, Events,
Event Details, and Trends tables.
When you select any of these tables, you can display the Condition Filter dialog
box.
For the Objects table, you can add a conditional filter that specifies the acceptable
age of the data on which the filter is applied. For example, if you specify 0 as the
acceptable age, the filter is always applied on the latest data from the field system.
If you specify 2 weeks, the age of the data with the cache is checked. If the data is
older than 2 weeks it is obtained from the field system, else the data from the
cache is used for filtering. This setting helps in the faster report generation.
Condition Filter Dialog Box
This dialog box allows you to specify the condition to filter the report data. You can
apply the Condition filter on all columns except columns of type date/time.