ComplianceSavedSearch Table

FlexNet Manager Suite (Cloud)

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 source 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

FlexNet Manager Suite (Cloud)

Current