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

Details

ComplianceSearchType RelationID

Type: integer. Key. Generated ID

A unique identifier for a relationship.

RelationName

Type: text (max 256 characters). Key

The unique internal name of this relation.

DescriptionResourceName

Type: text (max 256 characters). Nullable

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

DescriptionDefault

Type: text (max 256 characters)

The default description of the relationship.

FromSearchTypeID

Type: integer. Key

The ComplianceSearchType that represents the source of the relationship.

ToSearchTypeID

Type: integer. Key

The ComplianceSearchType that represents the destination of the relationship.

ToMany

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.

JoinClause

Type: text

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

FilterClause

Type: text

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

IsCustom

Type: boolean

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