open-index/open-npm huggingface dataset:
npm package: @hexa-ai/node-red-contrib-hexa-ai-edge
Description: Node-RED node for dataplug-history
Latest version: 1.0.7

@hexa-ai/node-red-contrib-hexa-ai-edge
=====================

Retrieves and aggregates historical data from the SQLite DataPlug database.

## Install

Run the following command in your Node-RED user directory - typically `~/.node-red`

        npm install node-red-contrib-dataplug

## Information

# DataPlug History

This subflow retrieves historical time-series data from a partitioned SQLite database and allows for configurable aggregation.

### Features

-   **Handles Time-Based Partitions**: Automatically queries the correct monthly data tables.
-   **Data Enrichment**: Attaches the correct measurement **unit**, **description**, and **category** from a `var` table.
-   **Flexible Time Range**: Supports dynamic (via `msg.payload`) and static (via node properties) time ranges.
-   **Configurable Aggregation**: Allows selecting the aggregation function (Average, Min, Max, Difference), time interval, raw data, or the last recorded value.
-   **Advanced Category Filtering**: If a category is selected, it will filter the results to only include channels within that category.

### Configuration

-   **`Default time range`**: Sets the time period to query.
-   **`Aggregation Function`**: Sets the SQL function for aggregation. 
-   **`Aggregation Interval`**: Sets the time window for grouping data. Select "None" for raw data or "Last Value Only" for the most recent point.
-   **`Filter by Category`**: A dropdown to select a category to filter by.

### Inputs

-   `channels` (Array, Optional): An array of channel names.
-   `from` (Number, Optional): Start timestamp in milliseconds.
-   `to` (Number, Optional): End timestamp in milliseconds.

### Outputs

-   `msg.payload` (Object): A single object where each key is a channel name. Each channel object contains `min`, `max`, `unit`, `description`, `category`, `start_time`, `end_time`, and an array of `records`.