SearchCriteria Table (201)

• 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) ●

SearchCriteria table relationship diagram

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.