ComplianceSearchTypeColumn Table
The ComplianceSearchTypeColumn
table identifies all columns that may be used in 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 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 |
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
|
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 |
RequiresSearchTypeID
|
Type: integer. Nullable For special cases, a column may need data from another compliance object as well.
Foreign key to the |
Mandatory
|
Type: boolean Set this field to |
PrimaryKey
|
Type: boolean Set this field to |
SelectByDefault
|
Type: boolean Set this field to |
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. |