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.

 

Tables: DT_LOGGER, DT_LOGGER_SERIES, DT_LOGGER_DATUM

 

Report Parameters

Logger

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.

Series

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)

Include DATUM_UTC_DT + DT_LOGGER.UTC_OFFSET_HRS in results.

Column Name: DATUM_LOGGER_DT

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

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.

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

Qualifier(s)

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

Remarks

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

 

Widget

Notes

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