• Share
    • Twitter
    • LinkedIn
    • Facebook
    • Email
  • Feedback
  • Edit
Show / Hide Table of Contents

SearchCriteriaGroup Table (202)

Some tooltip text!
• 1 minute to read
 • 1 minute to read

Criteria storage for Selection and other Find mechanisms

Fields

Name Description Type Null
SearchCriteriaGroup_id Primary key PK
SearchCriteria_id Owning model FK SearchCriteria
name The name of this criteria group String(254)
textId Extra information (descriptive) for this Criteria Group FK text ●
direction 0 = Add, 1 = Subtract this group from the total result Enum CriteriaGroupDirection
rank Rank order within this CriteriaModel UShort
active Should this group be executed UShort
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

SearchCriteriaGroup table relationship diagram

Indexes

Fields Types Description
SearchCriteriaGroup_id PK Clustered, Unique

Relationships

Table Description
associate Employees, resources and other users - except for External persons
SearchCriteria Criteria storage for Selection and other Find mechanisms
SearchCriterion 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.
© SuperOffice. All rights reserved.
SuperOffice |  Community |  Release Notes |  Privacy |  Site feedback |  Search Docs |  About Docs |  Contribute |  Back to top