Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| FilterId | int identity | 4 | √ | null |
|
|
Filter primary key - Unique identifier for each saved grid filter |
|
| GridIdString | nvarchar | 200 | √ | null |
|
|
Grid identifier - String identifier linking this filter to a specific grid view |
|
| FilterString | nvarchar | 1073741823 | √ | null |
|
|
Filter configuration - JSON or XML string containing the complete filter criteria and settings |
|
| Name | nvarchar | 200 | √ | null |
|
|
Filter name - User-defined name for the saved filter |
|
| CreateBy | int | 4 | √ | null |
|
|
Created by user - UserID of the person who created this filter |
|
| CreateDate | datetime | 16,3 | √ | null |
|
|
Creation date - Date when this 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 this filter was last modified |
|
| DatasourceName | nvarchar | 200 | √ | null |
|
|
Data source name - Name of the data source this filter applies to |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_GridViewFilter | Primary key | Asc | FilterId |
Relationships
Close relationships within degrees of separation
