ComplianceSavedSearch Table

The ComplianceSavedSearch table holds the name of a custom view and any descriptive information about it.

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 `ComplianceSavedSearch` table
Database Column	Details
`ComplianceSavedSearchID`	Type: integer. Key. Generated ID A unique identifier for a custom view.
`SearchName`	Type: text (max 64 characters). Nullable The name of the custom view.
`Description`	Type: text (max 1000 characters). Nullable A description of the custom view.
`SearchGridLayout`	Type: text. Nullable The grid layout used in the custom view.
`SearchSQL`	Type: text. Nullable SQL statement that generates the data set for the custom view.
`SearchSQLConnection`	Type: text (max 500 characters) SQL connection to use to execute search SQL: ‘Live’, ‘DataWarehouse’, ‘QuerySnapshot’, ‘ExternalFNMEA’, or connection string.
`SearchMapping`	Type: XML. Nullable Search query XML to SQL mapping.
`SearchXML`	Type: XML. Nullable Search query XML.
`CreatedBy`	Type: text (max 128 characters) The operator who created the custom view.
`CreationDate`	Type: datetime The date the custom view was created.
`ModifiedBy`	Type: text (max 128 characters). Nullable The operator who last modified the custom view.
`ModificationDate`	Type: datetime. Nullable The date the custom view was last modified.
`ComplianceSearchTypeID`	Type: integer. Key The type of the custom view. Foreign key to the `ComplianceSearchType` table.
`ComplianceSearchFolderID`	Type: integer. Key The folder in which this custom view is stored. Foreign key to the `ComplianceSearchFolder` table.
`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.
`CanDelete`	Type: boolean Set this to `False` for predefined custom views which an operator is not allowed to delete.
`CanChangeMasterObject`	Type: boolean Set this to `False` if the this view has a fixed master object.
`ComplianceSavedSearch SystemID`	Type: integer. Key. Nullable An identifier for a system custom view.
`SearchNameResourceName`	Type: text (max 256 characters). Nullable The unique name of the localizable resource string representing a column name. Foreign key to the `ComplianceResourceString` table.
`DescriptionResourceName`	Type: text (max 256 characters). Nullable The unique name of the localizable resource string representing a column name. Foreign key to the `ComplianceResourceString` table.
`SavedSearchLink`	Type: text. Nullable The saved built in report or view link.
`SavedSearchFilter`	Type: text. Nullable The saved filter for report or view