SearchCriteria Table (201)
•
Environment: onsite, online
Some tooltip text!
• 2 minutes to read
• 2 minutes to read
Criteria storage for Selection and other Find mechanisms
Fields
| Name | Description | Type | Null |
|---|---|---|---|
| SearchCriteria_id | Primary key | PK | |
| name | Name of this criteria collection | String(254) | |
| textId | Extra information (descriptive) for this Criteria set | FK text | ● |
| ownerType | Selection, Reporter, FindProject, ... | Enum OwnerType | ● |
| ownerTable | Table number of table that owns these criteria | TableNumber | ● |
| ownerId | Record ID in ownerTable that owns these criteria | RecordId | ● |
| registered | Registered when | UtcDateTime | |
| registered_associate_id | Registered by whom | FK associate | |
| updated | Last updated when | UtcDateTime | |
| updated_associate_id | Last updated by whom | FK associate | |
| updatedCount | Number of updates made to this record | UShort | |
| ownerName | Name of owner; this is the archive provider name in NetServer/SIX.web | String(254) | ● |
| ownerGuiName | Name of the owner GUI control, this is the GUI XML id in SIX.web | String(254) | ● |
| displayName | Display name when these criteria are a saved archive filter | String(254) | ● |
Indexes
| Fields | Types | Description |
|---|---|---|
| SearchCriteria_id | PK | Clustered, Unique |
| ownerId, ownerName, ownerGuiName | RecordId, String(254), String(254) | Index |
| ownerId, ownerTable, ownerType, ownerGuiName | RecordId, TableNumber, Enum, String(254) | Index |
Relationships
| Table | Description |
|---|---|
| associate | Employees, resources and other users - except for External persons |
| SearchCriteriaGroup | Criteria storage for Selection and other Find mechanisms |
| text | Long text fields from all over the system |
Replication Flags
- Area Management controlled table. Contents replicated to satellites and traveller databases.
- Replicate changes UP from satellites and travellers back to central.
- Copy to satellite and travel prototypes.
Security Flags
- No access control via user's Role.