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

SORCriteria Table (175)

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

SuperOffice reporter data

Fields

Name Description Type Null
SORCriteria_id Primary key PK
SORPublish_id Owning publish name FK SORPublish
fieldName Database field name String(29)
SOROperators_id Operator foreign key FK SOROperators
value1 First part of value String(254) ●
value2 Second part of value String(254) ●
useIt 1=criterion is in use, otherwise 0 UShort
whereOrder relative order in where clause 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
locked If 1, then this crierion is locked and its value cannot be changed outside of Reporter Studio Bool ●

SORCriteria table relationship diagram

Indexes

Fields Types Description
SORCriteria_id PK Clustered, Unique
SORPublish_id FK Index
SOROperators_id FK Index
useIt UShort Index
whereOrder UShort Index

Relationships

Table Description
associate Employees, resources and other users - except for External persons
SOROperators SuperOffice reporter data
SORPublish SuperOffice reporter data

Replication Flags

  • Replicate changes DOWN from central to satellites and travellers.
  • 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