ComplianceSearchFolder Table

The ComplianceSearchFolder table identifies a folder for storing a custom search (or view), and tracks the parent-child relationships of folders to establish their hierarchy.

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

Database Column



Type: integer. Key. Generated ID

A unique identifier for a saved search folder.


Type: text (max 128 characters). Key. Nullable

The name of the folder.


Type: integer. Key. Nullable

Identifies the parent that contains this folder. Foreign key to another folder in this ComplianceSearchFolder table.


Type: integer. Key

The kind of custom view stored in this folder. Foreign key to the ComplianceSearchType table.


Type: text (max 128 characters). Key. Nullable

The internal path to the folder.


Type: boolean. Nullable

Set this field to True to indicate that this folder holds generated searches.


Type: boolean. Nullable

Set this field to False for predefined folders which operators are not allowed to deleted.


Type: integer. Key. Nullable

ID of the operator who created the view. Foreign key to the ComplianceOperator table.


Type: integer. Key

Defined access type to the view. Foreign key to the RestrictedAccessType table.

ComplianceSearchFolder SystemID

Type: integer. Key. Nullable

An identifier for a system custom view folder.


Type: text (max 256 characters). Key. Nullable

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