User Guide

Reports
9
Reports Workspace
241
Siemens User Guide Version 2.1
A6V10415471_en_a_21
Building Technologies 2015-07-15
Table Name
Columns with possibility to display multiple values
in a single cell
Objects
Related Items Type
Related Items
Activities
Value
Previous Value
Quality
Previous Quality
Active Events Available Commands
For more information, see In Operator [➙ 317].
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 machine. Date 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