SearchCriterion Table (203)
• 4 minutes to read
• 4 minutes to read
Criteria storage for Selection and other Find mechanisms
Fields
| Name | Description | Type | Null |
|---|---|---|---|
| SearchCriterion_id | Primary key | PK | |
| SearchCriteriaGroup_id | Owning group | FK SearchCriteriaGroup | |
| criterionId | Usually DbFieldId of field to be searched | FieldId | |
| extraId | Extra info, forms part of the internal unique identification of the criterion | Id | ● |
| udefIdentity | Extra info for searching udef fields, to keep track of actual field across layout changes | Id | ● |
| operatorId | Operator ID | Enum CriterionOperator | |
| linkType | Link type, AND or OR | Enum CriterionLinkType | |
| active | Should this criterion be executed | UShort | |
| rank | Ordering within this group | 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 | |
| columnName | Column name from archive provider in NetServer/SIX.web | String(254) | ● |
| operatorName | Operator name from archive provider | String(254) | ● |
| uniqueKey | Unique key (hash) from ArchiveRestrictionInfo | Id | ● |
| parenthesis | Parenthesis value, positive is number of opening parentheses to prepend to this criterion, negative is the number of closing parentheses to append | Short | ● |
| Operator | ID | Comment |
|---|---|---|
| enInvalidOperator | 0 | Invalid |
| enDateIsEqual | 1 | Date is equal |
| enAllBefore | 2 | All before |
| enAllAfter | 3 | All after |
| enAllBeforeToday | 4 | All before today |
| enAllAfterToday | 5 | All after today |
| enLastWeek | 6 | Last week |
| enThisWeek | 7 | This week |
| enNextWeek | 8 | Next week |
| enLastMonth | 9 | Last month |
| enThisMonth | 10 | This month |
| enNextMonth | 11 | Next month |
| enLastQuarter | 12 | Last quarter |
| enThisQuarter | 13 | This quarter |
| enNextQuarter | 14 | Next quarter |
| enThisHalfYear | 15 | This half year |
| enThisYear | 16 | This year |
| enFromTo | 17 | From to |
| enTodayIsEqual | 46 | Today is equal |
| enBeginsWith | 18 | Begins with |
| enDoesNotBeginWith | 19 | Does not begin with |
| enIsEqual | 20 | Is equal |
| enIsNotEqual | 21 | Is not equal |
| enContains | 22 | Contains |
| enDoesNotContain | 23 | Does not contain |
| enOperatorLessThan | 24 | Less than |
| enOperatorGreaterThan | 25 | Greater than |
| enOperatorEquals | 26 | Equals |
| enOperatorLessOrGreaterThan | 27 | Less or greater than |
| enOperatorBetween | 28 | Between |
| enListIsEqual | 29 | List is equal |
| enListIsNotEqual | 30 | List is not equal |
| enBooleanIsEqual | 31 | Boolean is equal |
| enTreeIsEqual | 32 | Tree is equal |
| enTreeIsNotEqual | 33 | Tree is not equal |
| enListCurrentAssociate | 34 | List current associate |
| enWeek | 35 | Week |
| enWeekLast | 36 | Week last |
| enWeekThis | 37 | Week this |
| enWeekNext | 38 | Week next |
| enMonth | 39 | Month |
| enMonthLast | 40 | Month last |
| enMonthThis | 41 | Month this |
| enMonthNext | 42 | Month next |
| enSelectionIsEqual | 43 | Selection is equal |
| enProjectIsEqual | 44 | Project is equal |
| enContactIsEqual | 45 | Contact is equal |
| enFirstWorkHourIsEqual | 47 | First work hour is equal |
| enListIsOneOf | 1000 | illustrate that the values selected should be one-of |
| enListIsNotOneOf | 1001 | illustrate that the values selected should be not-one-of |
| enOlderThan | 1100 | Older than |
| enNewerThan | 1101 | Newer than |
| enStatusIsSet | 1200 | Is Equal To 1 - used by Saint status monitors |
| enBetween | 1250 | Between |
Indexes
| Fields | Types | Description |
|---|---|---|
| SearchCriterion_id | PK | Clustered, Unique |
Relationships
| Table | Description |
|---|---|
| associate | Employees, resources and other users - except for External persons |
| SearchCriteriaGroup | Criteria storage for Selection and other Find mechanisms |
| SearchCriterionValue | Criteria storage for Selection and other Find mechanisms |
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.