Versions Compared

Old Version 2

changes.mady.by.user Chad Kienle

Saved on

compared with

New Version 3

changes.mady.by.user Wes Johnson

Saved on

Key

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

...

A Table Setting consists of a Table Name and various optional filters.


Info
titleImportant Note

When creating a dynamic table name using tokens, the values must contain only valid characters allowed in the database table name.


  • Table Name
    • The name of the table where records will be inserted.  This name can be statically defined or be dynamically build up using the following tokens
      • ${type} - The Record Type of the record being inserted
      • ${group} - The Sparkplug Group ID of the record being inserted
      • ${edgenode} - The Sparkplug Edge Node ID of the record being inserted
      • ${device} - The Sparkplug Device ID of the record being inserted
      • ${field:<name>} - The value of any field of the record being inserted where <name> is the name of the field
  • Enabled
    • Whether this Table Setting is enabled
  • Record Type
    • An optional Record Type to filter on. If specified, only records with this Record Type will be placed in the table.
  • Group ID
    • An optional Sparkplug Group ID to filter on. If specified, only records with this Group ID will be placed in the table.
  • Edge Node ID
    • An optional Sparkplug Edge Node ID to filter on. If specified, only records with this Edge Node ID will be placed in the table.
  • Device ID
    • An optional Sparkplug Device ID to filter on. If specified, only records with this Device ID will be placed in the table.
  • Field Filters
    • An optional semicolon delimited list of field filters.  Each field filter is declared using one of the following forms: {<field>:<operator>:<value>}, {<field>:NULL}, or {<field>:NOTNULL}
      • <field> - the name of the field to filter on.
      • <operator> - the filter operator.  Must be one of the following: ==, !=, >, <, >=, or <=
      • <value> - the value of the field.
    • Values that contain ':', ';', or '\' characters must have the character escaped with a leading '\' character.
    • Examples:
      • To only insert records that match a "serial_number" field equal to "0123456" the filter would be: {serial_number:==:0123456}
      • To only insert records that contain a "temp1" field the filter would be:  {temp1:NOTNULL}
      • To exclude records that match a "unit_id" field equal to "112:008:32455" the filter would be: {unit_id:!=:112\:008\:32455}

...