Live Date Series Data Agent

<< Click to Display Table of Contents >>

Navigation:  Live > Agents > Reporting Agents >

Live Date Series Data Agent

The Date Series Data report is a generic report for viewing logger data, available in EQuIS Live.


Viewing Data


The Date Series Data report can be run as a scheduled EQuIS Information Agent (EIA), at the desired frequency, to automatically view data as often as needed.


The report can also be run in EQuIS Professional or Enterprise (using the EZView widget) to view the data manually, without having to schedule an EIA. It has the following input parameters:

Facility – Select a facility. The report only shows the Logger(s) and Series that belong to this facility.

Logger(s) Select the desired loggers. Only the loggers for the selected facility are displayed. The loggers must also have one or more DT_LOGGER_SERIES with SERIES_TYPE set to NULL or 'DATUM' to be displayed. If you do not select any loggers, the report will return data for all loggers.

Series Select the desired series. Only the series for the selected facility are displayed. If Logger(s) are selected, only the series for the selected Logger(s) are displayed. If you do not select any series, the report will return data for all series.

Time Formats – Select one or more of the time formats from the following table.


Time Format

Column Name (in results)


UTC (Coordinated Universal Time)



Local time of the logger (not adjusted for DST)



UTC offset hours (not adjusted for DST)


DT_LOGGER_DATUM.DATUM_UTC_DT + UTC offset hours (e.g., enter -5 for Eastern Time, or -3.5 for Newfoundland)


Date Range – Select a start and end date for the data.

Qualifier(s) – Select one or more qualifiers to limit the data returned by the report.

Max Decimal Digits Optional, enter the amount of decimal digits needed in returned values, between 0 and 9.

NULL Qualifier Swap Optional, enter a value with which NULL DATUM_QUALIFIER values will be replaced. Needed when using this report as data source in the Time Series Widget and grouping data by DATUM_QUALIFIER.

Remarks – Optional, show remarks and remark types for the data. A DT_LOGGER_REMARK ("remark") row is shown for a DT_LOGGER_DATUM ("datum") row if:

a.The remark's LOGGER_ID matches the datum's and the remark's LOGGER_SERIES_ID is NULL (i.e., it is for all of this logger's DT_LOGGER_SERIES ("series")) or the remark's LOGGER_SERIES_ID is equal to the datum's LOGGER_SERIES_ID (i.e., it is only for this series), and

b.The remark's REMARK_UTC_DT is equal to the datum's DATUM_UTC_DT, or, if the remark's DURATION_S is not NULL, if the datum's DATUM_UTC_DT is >= REMARK_UTC_DT and <= REMARK_UTC_DT + DURATION_S seconds.




Show Remarks

Check this parameter to show the DT_LOGGER_REMARK.REMARKs in a dedicated remark column.

Show Remark Types

Check this parameter to show the DT_LOGGER_REMARK.REMARK_TYPEs in a dedicated REMARK_TYPE column.

Show Only Remarks with Type

Select one or more DT_LOGGER_REMARK.REMARK_TYPEs, to limit the remarks shown by the report. If nothing is selected, and Show Remarks and/or Show Remark Types is checked, it shows all remarks and/or all remark types.


If a datum row has multiple REMARKs (and REMARK_TYPEs), the REMARKs (and REMARK_TYPEs) are separated by pipes. An empty string is displayed if a REMARK or REMARK_TYPE is NULL (or an empty string), to be consistent with the way EQuIS displays other (NULL) values. The pipes are not removed if a REMARK or REMARK_TYPE is an empty string. Thus, users can see which REMARK_TYPE belongs to which REMARK. For example, REMARK_TYPE = |Type 1, and REMARK = Remark 1|Remark 2; Remark 1's type is NULL (or an empty string), and Remark 2's type is Type 1. If the leading pipe was not present in REMARK_TYPE, the user would not know which Remark's type was Type 1.


Show Coordinates – Check this parameter to show X and Y coordinates (and FACILITY_ID) when displaying (e.g., to show logger data in Traffic Light Widget, and/or Traffic Light Map Widget).

Show Inactive Data – Check this parameter to show (active and) inactive data. Data is active if both its series and logger have STATUS_FLAG = 'A', otherwise it is inactive.


Viewing Data in Widgets


This report can be used to view EQuIS Live data in the following widgets:




Time Series Chart Widget

When grouping data by DATUM_QUALIFIER, please utilize Swap Null Qualifier parameter.

Traffic Light Widget

Check Show Coordinates parameter to show x and y coordinates (and FACILITY_ID).

Traffic Light Map Widget