Applying Filters

You can apply the following types of filters to condense the displayed data in a report.

 

Prerequisites:

  • System Browser is in Application View.
  • Applications > Reports is selected.
  • The report to which you want to apply the filter is selected.

 

Name Filter
  1. Select a table or plot in the report definition.
  1. Do one of the following:
  • Click Dialog Launcher in the Name Filter group box.
  • Right-click the selected table or plot and select Name Filter from Filters.
  • Double-click inside the Name Filter group box.
  • The Name Filter dialog box displays.
  1. Select the Name or Description. The default selection is Name. The selection is the same as in the Display Mode List Box in System Browser.
  1. To set the Name filter, do one of the following:
  • In the Name Filter text box, type the complete path of the object for which you want to apply the Name filter according to System Browser Name.
    For example: SystemName.Management View.Project.Field Networks.BACnet Network 1.Hardware.Simulator Device 57291.Local_IO.Analog Input 1.*
    NOTE: Adding a “.*” at the end of the name or selecting the Children check box enables the children option.
    For a plot, you can apply only one Name filter and the Children check box is unavailable.
  • Drag a System Browser object onto the selected table or plot and the Name filter is set to the hierarchy of the dropped object.
    You can view and modify it using the Name filter dialog box.
    NOTE: When you drag an object for the first time onto a table, the default filter *:* is replaced by the hierarchy of the dragged and dropped object.
  1. Click New.
  • The Name filter is added to the Name Filter list.
  1. Click OK.
  • The Name filter is added to the Name Filter group box.

NOTE:
You can apply multiple Name filters on all tables except for a Trends table. For BACnet tables, applying multiple Name filters is possible, but the Children check box is unavailable.

Condition Filter
  1. Select a table in the report to which you want to apply the condition filter.
  1. Do one of the following:
  • Click Dialog Launcher in the Condition Filter group box.
  • Right-click the selected table and select Condition Filter from Filters.
  • Double-click inside the Condition Filter group box.
  • The Condition Filter dialog box displays.
  1. Select a column from the Available columns list.
    NOTE: For Objects Table: A Type drop-down list displays. Select an object from the list and click the Load button to populate the Available columns list.
  • The operators and values associated with the selected column display in the Operator and Values list.
  1. Select the required Operator and Value from the respective lists. If values are not displayed for the selected column, type in the value.
    NOTE: You have to specify time related values in a 24-hour clock format. For example, to specify the Source Time as 2.00 PM, type 14.00.
  • Use AND, OR, () to form the Filter expression.
  1. (Optional) For Objects table only, specify the acceptable age of the data on which the filter is applied by selecting the Read data from field system older than option.
  • The value entered is compared with the age of the data in the cache.
    If the data in the cache is older than the value entered, it is retrieved from the field system; otherwise data from the cache is used for filtering.
  1. Click Add.
  • The filter expression formed displays in the Filter expression field.
  1. Click OK.
  • The filter expression is displayed in the Condition Filter group box.

NOTE:
In order to apply Condition Filter on Previous Value and Value column of the Activities/All Logs report, or on the Event Value column of the Events/Event Details report respectively, enclose the value entered in the Values text field within double quotes, if it is in the 2E63 to 2E64-1 range. In the Trends table, the precision for a 64 bit value is supported till 2E49 (15 digits).

 

Time Filter
  1. Select a table in the report to which you want to apply the time filter.
  1. Do one of the following:
  • Click Dialog Launcher in the Time Filter group box.
  • Right-click the selected table and select Time Filter from Filters.
  • Double-click inside the Time Filter group box.
  • The Time Filter dialog box displays.
  1. For Events, Activities, Orphan Events and Orphan Activities table only, select the column on which you want to apply the time filter from the Select Column drop-down list.
  1. Select the appropriate values for Date time specification: Exact, Custom, or Relative.
  1. From the Trend Interval drop-down list, select the interval in which the trend data has to be displayed.
    NOTE: The Trend Interval drop-down list is only available for Trends table.
  1. Click OK.
    NOTE: By default, the Unlimited option is selected.
  • The Time filter is added in the Time Filter group box.
Graphics Filter
  1. Select the report to which you want to apply the graphics filter.
  1. Assign the name filter of the object whose graphics and view ports you want to display in the report output.
  1. Select the All Related Graphics check box from the Graphics group box in the Filter tab.
  • All the graphics and viewports related to the object display in Run mode.
Row Filter
  1. Select the report to which you want to apply the row filter.
  1. Click the Filter tab and thereafter select the Row filter check box.
  1. Enter the desired number of rows to be displayed in the report output.
  • The configured number of rows are displayed for the table in Run mode.