Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Records are published in a Sparkplug-like format on a topic such as spBv1.0/group/NRECORD/edgenode or spBv1.0/group/DRECORD/edgenode/deviceand a payload in JSON format containing the metric name as the Record Type and associated tags such as:

...

  • Enabled
    • Checkbox to enable/disable the MQTT Recorder module. Selected by default.
  • Datasource
    • A dropdown list to select the database connection to use for record storage.  This list is populated with the database connections set up within the Ignition Gateway.
  • Partition Period
    • The partitioning period to use for record tables within database.  Each table name will be appended with a date indicating the partition time period.  For example, if table were created for "alarm" records on December 10, 2022 at 2:00 AM, the table name for each partition type would be:
      • None: tablename
      • Hourly: tablename_2022_12_10_02
      • Daily: tablename_2022_12_10
      • Weekly: tablename_2022_49
      • Monthly: tablename_2022_12
      • Yearly: tablename_2022

...

By default, a single table will be defined for MQTT Recorder with a table name of rs_${type}. With this single table definition, a separate table will be created for each unique record type however you can create custom table names using the additional filters described below. 

Anchor
TablesMain
TablesMain
Tables - Main

...