AlertTarget Table

The AlertTarget table stores the links between alerts and other tables in the database.

Note: To cater for multi-tenant mode, this table may contain data for multiple tenants. Access requires that the database TenantID has been set in the SQL Server connection context information. That setting filters an underlying table to produce this view of data for the single, selected tenant.
Table 1. Database columns for AlertTarget table

Database Column

Details

AlertID

Type: integer. Key

Link to the Alert table

TargetTypeID

Type: integer. Key

A link the the TargetType table. this value specifies which kind of object the alert is linked to.

TargetID

Type: integer. Key

used to attach the Alert to its target. The target table depends on the TargetTypeID of the linked AlertType.

FieldName

Type: text. Nullable

A semi-colon separated list of view-model names that represent the fields that the alert is attached to. A null value indicates that the alert applies to the overall object as a whole.