ComplianceSearchTypeRelation Table
The ComplianceSearchTypeRelation
table tracks relationships between different objects for which
operators can create custom views.
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.
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 |
DescriptionDefault
|
Type: text (max 256 characters) The default description of the relationship. |
FromSearchTypeID
|
Type: integer. Key The |
ToSearchTypeID
|
Type: integer. Key The |
ToMany
|
Type: boolean Set this field to |
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. |