QuickFilter


Description

Quick filters and saved searches managing user-defined filter criteria and search parameters for data views and reports. This table stores filter definitions including names, descriptions, criteria, parent relationships, and marketplace flags to support customizable data filtering, saved searches, and user productivity features for healthcare data management and reporting.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
Id int identity 4 √ null

Primary key - Unique identifier for each quick filter
Name nvarchar 400 √ null

Filter name - Name of the quick filter for user identification
Description nvarchar 400 √ null

Filter description - Detailed description of what the filter does
Criteria nvarchar 1073741823 √ null

Filter criteria - JSON or serialized filter criteria and conditions
ParentType nvarchar 100 √ null

Parent type - Type of parent object this filter applies to (Table, View, Report, etc.)
ParentId nvarchar 100 √ null

Parent identifier - Identifier of the parent object this filter is associated with
CreateBy int 4 √ null

Created by user - UserID of the person who created this filter
CreateDate datetime 16,3 √ null

Creation date - Date when the filter was created
UpdateBy int 4 √ null

Updated by user - UserID of the person who last updated this filter
UpdateDate datetime 16,3 √ null

Last update date - Date when the filter was last updated
IsMarketPlace bit 1 ((0))

Marketplace flag - Boolean indicating if this filter is available in the marketplace

Indexes

Constraint Name Type Sort Column(s)
PK_QuickFilter Primary key Asc Id

Relationships

Close relationships within degrees of separation