ComplianceSearchTypeRelation Table

The ComplianceSearchTypeRelation table tracks relationships between different objects for which operators can create custom views.

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 ComplianceSearchTypeRelation table

Database Column


ComplianceSearchType RelationID

Type: integer. Key. Generated ID

A unique identifier for a relationship.


Type: text (max 256 characters). Key

The unique internal name of this relation.


Type: text (max 256 characters). Nullable

The unique name of the localizable resource string representing a relationship name. Foreign key to the ComplianceResourceString table.


Type: text (max 256 characters)

The default description of the relationship.


Type: integer. Key

The ComplianceSearchType that represents the source of the relationship.


Type: integer. Key

The ComplianceSearchType that represents the destination of the relationship.


Type: boolean

Set this field to True to allow more than one related row in the destination table for each row in the source table. If this field is False, rows have a one-to-one relationship.


Type: text

The SQL join clause used to join the source object with a related object.


Type: text

The SQL filter clause used to filter the source object with a related object.


Type: boolean

False if the relation is out of the box, false otherwise.