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	Details
`ComplianceSearchFolderID`	Type: integer. Key. Generated ID A unique identifier for a saved search folder.
`Name`	Type: text (max 128 characters). Key. Nullable The name of the folder.
`ParentFolderID`	Type: integer. Key. Nullable Identifies the parent that contains this folder. Foreign key to another folder in this `ComplianceSearchFolder` table.
`ComplianceSearchTypeID`	Type: integer. Key The kind of custom view stored in this folder. Foreign key to the `ComplianceSearchType` table.
`Path`	Type: text (max 128 characters). Key. Nullable The internal path to the folder.
`PredefinedSearchesCreated`	Type: boolean. Nullable Set this field to `True` to indicate that this folder holds generated searches.
`CanDelete`	Type: boolean. Nullable Set this field to `False` for predefined folders which operators are not allowed to deleted.
`CreatedByOperatorID`	Type: integer. Key. Nullable ID of the operator who created the view. Foreign key to the `ComplianceOperator` table.
`RestrictedAccessTypeID`	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.
`NameResourceName`	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.