ComplianceSearchTypeColumn Table

The ComplianceSearchTypeColumn table identifies all columns that may be used in 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 ComplianceSearchTypeColumn table

Database Column

Details

ComplianceSearchType ColumnID

Type: integer. Key. Generated ID

A unique identifier for a custom view column.

ColumnName

Type: text (max 128 characters). Key

The default value of the display column name.

ColumnNameResourceName

Type: text (max 256 characters). Nullable

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

QuerySetup

Type: text. Nullable

Query pre-calculation statement executed before the custom view query.

FromTable

Type: text. Nullable

The name of the database table where the column can be found.

SelectName

Type: text. Nullable

The name of the column in the database.

JoinClause

Type: text. Nullable

The SQL join that links other tables to provide the relevant data for this column.

WhereClause

Type: text. Nullable

The SQL “WHERE” statement that limits the information returned by the custom view.

SelectOptionsSQL

Type: text. Nullable

The SQL that selects the predefined list that the user can display when filtering on this column.

FilterGroupType

Type: integer. Nullable

An ID that indicates the kind of value expected in this column, which in turn determines what kinds of filter options (such as Contains, Starts With) will be offered for this column. Possible values (and their associated meanings) are:

  • 1 = string
  • 2 = number
  • 3 = list
  • 4 = date
  • 5 = group
  • 6 = money
  • 7 = boolean.
DefaultFilterType

Type: integer. Nullable

The type of field that should be used to search for information in this column. Possible values (and their associated meanings) are the same as for the previous field.

ComplianceSearchTypeID

Type: integer. Key

The type of that the column is related to. Foreign key to the ComplianceSearchType table.

RequiresSearchTypeID

Type: integer. Nullable

For special cases, a column may need data from another compliance object as well. Foreign key to the ComplianceSearchType table.

Mandatory

Type: boolean

Set this field to True if this column must always be returned in the SQL “SELECT” statement.

PrimaryKey

Type: boolean

Set this field to True if this column is the primary key of the SQL “SELECT” statement.

SelectByDefault

Type: boolean

Set this field to True if this column should be included (checked) by default when the operator is creating a custom view. If False, the operator may include it manually.

IsCustom

Type: boolean

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

LinkAction

Type: text (max 64 characters). Nullable

The action to be used for the drill through link on this column.

LinkController

Type: text (max 64 characters). Nullable

The controller to be used for the drill through link on this column.

LinkIndicateOrigin

Type: boolean

Whether the drill through link on this column contains the report page URL as the origin URL.

LinkFragmentField

Type: text (max 64 characters). Nullable

The fragment field name to be used for the drill through link on this column.

IsMultiEditEnabled

Type: boolean

Whether the multiple object drill through is enabled on this object type.

MultiEditConditionField

Type: text. Nullable

Field on which the multiple object drill through will be evaluated against.