Live Date Series Data Agent

<< Click to Display Table of Contents >>

Navigation:  Live > Agents > Reporting Agents >

Live Date Series Data Agent

Report Name: EQuIS Live: Date Series Data (example)

File Name: EarthSoft.Live.Reports.dll


Description: The EQuIS Live: Date Series Data report allows users to retrieve logger data in EQuIS Professional and Enterprise.




Report Parameters


Select the desired logger(s).

Only loggers for the currently selected facility will be available. The loggers must also have one or more series with SERIES_TYPE set to NULL or 'DATUM'.

If no logger is selected, data for all loggers will be retrieved.


Select the desired series.

If one or more loggers are selected, only series for the selected logger(s) will be retrieved. If no series is selected, data for all series will be retrieved.

Time Formats

Select one or more time formats to be included as columns in the results.

Note: Time Formats is not used (e.g., with the Date Range) to filter what data are retrieved.

UTC (Coordinated Universal Time)

Include DATUM_UTC_DT in results.

Column Name: DATUM_UTC_DT

Local time of the logger (not adjusted for DST)



UTC offset hours (not adjusted for DST)

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

Column Name: DATUM_UTC_DT+/-##:##:##

Date Range

The report returns data where DT_LOGGER_DATUM.DATUM_UTC_DT is between the Start Date and End Date. The Start Date and End Date are expected to be UTC.

Note: The Start Date and End Date values are not limited to the predefined dynamic values in Enterprise. These values can also be updated manually (e.g., by updating ST_USER_REPORT_PARAMETER.PARAM_VALUE). For example, in Enterprise, "Today" is today at midnight, and uses the server's local time, but it can be manually changed to use UTC, and/or a time other than midnight.

To include time and time zone as part of the parameters, the user must modify the ST_USER_REPORT_PARAMETER.PARAM_VALUE for Start Date and End Date for a user report that produces an EIA.

For example, the dynamic value for Today (set by EQuIS Enterprise) is $select dateadd(dd, 0, datediff(dd, 0,getdate())). However, users can manually change the parameter to use UTC, and/or a time other than midnight through the use of SQL functions, e.g., $select dateadd(hh, -5, dateadd(dd, 0, datediff(dd, 0,getutcdate()))). The '$' specifies that the parameter value is SQL instead of a constant value. Users can run these selects in SSMS to debug them.

Start Date

Enter the desired start date (defaults to the first day of the current month).

End Date

Enter the desired end date (defaults to the first day of the following month).


Optionally, select one or more datum qualifiers (from RT_LOGGER_QUALIFIER) to filter the data based on the selected qualifier(s).

Max Decimal Digits

Optionally, enter the maximum number of decimal digits desired in the retrieved DATUM_VALUEs, between 0 and 9.

NULL Qualifier Swap

Optionally, replace NULL DATUM_QUALIFIERs with this value in the report output (e.g., to display data in the Time Series Chart Widget and group data by DATUM_QUALIFIER).


Optionally, show remarks and remark types (from DT_LOGGER_REMARK) for the data.

A remark row is shown for a datum row if:

1.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 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

2.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.

If a datum row has multiple remarks (and remark types), they 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.

Show Remarks

Check this parameter to show the remarks.

Show Remark Types

Check this parameter to show the remark types.

Show Only Remarks with Type

Select one or more REMARK_TYPEs to filter 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.

Show Coordinates

Check this parameter to retrieve X and Y coordinates, and FACILITY_ID, for each datum, e.g., to display data in the Traffic Light Widget, and/or Traffic Light Map Widget.

Show Inactive Data

Check this parameter to retrieve (active and) inactive data.

Data is active if both its series and logger have STATUS_FLAG = 'A', otherwise it is inactive.

Additional Fields

Select additional table columns to include in results.

The columns for the DT_LOGGER, DT_LOGGER_SERIES, and DT_LOGGER_DATUM tables are included by default, and other tables can also be added by providing join conditions. For more info see How To Customize Additional Fields Parameter.

Extra Selects

Add extra selects to include in results, for example:

equis.unit_conversion(DATUM_VALUE, SERIES_UNIT, 'deg F', 9999999) AS [Temperature (deg F)]

For more info see Extra Selects.

Note: This parameter is hidden by default.

* This report also includes hidden parameter: Facility



Note: If the report did not retrieve any data, then the SQL query that the report used to try to retrieve the data is included in the report output. The SQL query (which can be executed using the EQuIS SQL Form or SQL Server Management Studio) may help to troubleshoot issues. And it is also a good way to see how to add Additional Fields and Extra Selects.



Enterprise Widgets


This report can also be used in EQuIS Enterprise widgets to visualize logger data (e.g., together with other types of data in EQuIS).




Time Series Chart Widget

The NULL Qualifier Swap parameter can be used used to group data by DATUM_QUALIFIER.

Traffic Light Widget

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

Traffic Light Map Widget