Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| AppliesTo | Unknown | 0 | null |
|
|
Applies to - Which reports or data views this filter can be applied to |
||
| CreatedBy | Unknown | 0 | null |
|
|
Created by - Reference to the user who created this filter |
||
| CreatedDate | Unknown | 0 | null |
|
|
Creation date - Date when the filter was created |
||
| Id | int identity | 4 | √ | null |
|
|
Data field - Id information for CustomFilter business operations |
|
| Name | nvarchar | 400 | √ | null |
|
|
Name field - Descriptive name or identifier for CustomFilter records |
|
| Description | nvarchar | 400 | √ | null |
|
|
Description field - Detailed description or explanation of CustomFilter information |
|
| Criteria | nvarchar | 1073741823 | √ | null |
|
|
Text field - Criteria text information for CustomFilter records |
|
| CreateBy | int | 4 | √ | null |
|
|
Numeric value - Quantity, count, or numeric measurement for CustomFilter records |
|
| CreateDate | datetime | 16,3 | √ | null |
|
|
Date/time field - Date and time when create occurred or was recorded |
|
| FilterCriteria | Unknown | 0 | null |
|
|
Filter criteria - JSON or XML representation of the filter conditions |
||
| FilterDescription | Unknown | 0 | null |
|
|
Filter description - Description of what the filter does |
||
| FilterID | Unknown | 0 | null |
|
|
Primary key - CustomFilter unique identifier for each custom filter |
||
| FilterName | Unknown | 0 | null |
|
|
Filter name - User-defined name for the custom filter |
||
| Unknown | 0 | null |
|
|
Shared flag - Whether this filter is shared with other users |
|||
| ParentType | nvarchar | 100 | √ | null |
|
|
Type classification - Category or classification type for CustomFilter records |
|
| ParentId | nvarchar | 100 | √ | null |
|
|
Text field - ParentId text information for CustomFilter records |
|
| UpdateBy | int | 4 | √ | null |
|
|
Date/time field - Date and time when upby occurred or was recorded |
|
| UpdateDate | datetime | 16,3 | √ | null |
|
|
Date/time field - Date and time when up occurred or was recorded |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_QuickFilter | Primary key | Asc | Id |