History list

Filter inputs

To filter the data, the following inputs can be set in the filter input area, where depending on the type different criteria are supported.

../../_images/visu_hist_inputs.png

When the history list is opened, the advanced filters are hidden and can be shown by clicking the button Advanced filters.

The filter Type defines which types (Value, Event, Alarm, Aggregate) are included in the search. Following criteria can be used with all types:

From

Start time.

To

End time.

Number of rows

Maximum number of rows to request.

Hint

By clicking on visu_hist_range you can select between three possible ways to specify the time range respectively the number of rows:

  • From - To – This is the default and allows you to specify start and end time.

  • From - Number of rows – You can specify a start time and a number of rows. You will get at most the specified number of rows starting with start time and going towards present.

  • Number of rows - To – You can specify an end time and a number of rows. You will get at most the specified number of rows, starting with the end time and going towards past.

In any case the given time is always the time of the occurrence of the historized entry (source time, alarm state change, …).

Address

Address of the historized entry:

  • Type Value: NodeId

  • Type Alarm: Alarm condition

  • Type Event: Name of the event

Hint

You can select a data variable from your server by using the pointpointpoint selector.

Value

Value of the historized entry. Related to the attribute value for the types Value and Aggregate and to the alarm triggering value for the type Alarm. Not used for the type Event.

Archive

Raw archive for values, aggregate archive for aggregates, event archive for alarms and events.

Additional for types Alarm and Event:

Username

User who caused the historized entry.

Message

Active/inactive text for alarms, event text for events.

Min.-Severity

Minimum priority of the historized entry. Everything greater or equal than this priority will be returned.

For type Aggregate the desired aggregate function and interval can be set. Depending on the type of the server the selection of the aggregate is different:

  • atvise server – You can select one of the parameterized functions of all aggregate templates in the project.

    Hint

    Even though you directly select a function of an aggregate template, only the parameters aggregate function, interval and unit are used for the query. Because of this the server response can include results of other variables that use aggregate templates with the same combination of parameters.

  • webMI server – Aggregate function, interval and unit can be set to arbitrary values, because the webMI server is not able to tell the browser the list of supported aggregates.

Hint

  • To activate a filter, click the button Apply filter for archived data or activate the live checkbox for live data. If the live checkbox is activated, the filter cannot be edited. To edit the filter the checkbox has to be deactivated.

  • The type Aggregate cannot be filtered concurrently with any other type.

  • If the type Aggregate is selected it is not possible to switch to the live mode and specific filters (Aggregate, Interval) are shown.

  • If multiple types are selected, fields are only considered for entries which contains the respective field. E.g. a username will be ignored for entries of type Value.

  • Entries for the From time are always included while entries for the To time are always excluded.

  • For the filters Address, Username, Message and Value, the value of the input field must be contained in the attribute of the entry, an exact match is not required.

  • Since the given address must only be a substring of the result (and not an exact match), the corresponding access rights cannot be checked when filtering addresses. Therefore, in case of missing read permissions for the given address, no data is returned without displaying any permission error.

Data output

Clicking on the Apply filter button or activating the Live checkbox will send the query to the atvise server. The resulting data is listed in the table below the input area.

../../_images/visu_hist_output.png

Columns of the history list

The returned data can be further filtered by using the input fields of the respective columns. The checkbox next to an input field allows to switch the filter mode. If the checkbox is active, a specific filter for the respective column can be entered. In this case, it is also possible to filter for empty fields, e.g. in order to find the user Anonymous. If inactive, all entries are displayed. The filter checkbox can be configured via filterCheck in the global list.

Information on how to personalize the history list can be found in the corresponding Object Display help. This list is based on the same table than the alarm list, for details about more features see also alarm list.

The list contains the following columns:

Sev.

Severity of the historized entry (for alarms and events).

Time

Time of the occurrence of the historized entry.

Address

Address of the data variable which caused the historized entry.

  • Type Alarm: Alarmcondition

  • Type Value: NodeId

  • Type Event: Name of event

Type

Type of the historized entry (Alarm, Event, Value).

Message

Active/inactive text for alarms, event text for events.

Value

Value of the historical entry (raw value, aggregated value or alarm triggering value).

User

User who caused the historized entry (only for alarms and events).

There is also a smaller version of the history list, optimized for devices with small displays (e.g. tablets and mobile phones). This smaller version provides less options for filtering the query and by default shows a reduced number of columns.