Validation Registry entry

Specify what validation should occur when a term is entered into a column that uses the Thesaurus.

Usage

This Registry entry can be assigned to users and groups:

Key User User Group Group Group Group
Key 1 User User Group Group Group Group
Key 2 user user group group Default Default
Key 3 Table Table Table Table Table Table
Key 4 table Default table Default table Default
Key 5 Thesaurus
Key 6 Validation
Key 7 column or Default
Value setting
User user Table table Thesaurus Validation column setting
User user Table Default Thesaurus Validation column setting
Group group Table table Thesaurus Validation column setting
Group group Table Default Thesaurus Validation column setting
Group Default Table table Thesaurus Validation column setting
Group Default Table Default Thesaurus Validation column setting
User user Table table Thesaurus Validation Default setting
User user Table Default Thesaurus Validation Default setting
Group group Table table Thesaurus Validation Default setting
Group group Table Default Thesaurus Validation Default setting
Group Default Table table Thesaurus Validation Default setting
Group Default Table Default Thesaurus Validation Default setting

where:

column

is a back-end column name; or use Default for all columns in the specified table(s).

setting

can be:

Candidate

The Thesaurus is searched to determine whether or not this term is included. If the term is not in the Thesaurus, the user will be given the option to add the term. If they choose to add the term, it will be accepted for use, otherwise the user will be required to enter another term that is in the Thesaurus.

Relaxed

The Thesaurus is searched to determine whether or not this term is included. If the term is not in the Thesaurus, the user will be informed and asked whether they still wish to use the term:

  • If the user wishes to use the term, they can but the term is not added to the Thesaurus.
  • If the user does not wish to use the term, they will be required to enter another term.

Strict

The Thesaurus is searched to determine whether or not this term is included. If the term is not in the Thesaurus, the user will be informed that no match was found and they will be required to enter another term from the Thesaurus.

None

No validation is performed. The user can add / edit values without any entry being added to the Thesaurus.

Note: In the absence of this entry, a setting of Strict is assumed.

Examples

To allow users to add new terms to the Thesaurus:

Key Setting
Key 1 Group
Key 2 Default
Key 3 Table
Key 4 Default
Key 5 Thesaurus
Key 6 Validation
Key 7 Default
Value Candidate

To disallow users in group Researchers from adding new terms to a Thesaurus or to force values for a column to always be taken from the Thesaurus:

Key Setting
Key 1 Group
Key 2 Researchers
Key 3 Table
Key 4 Default
Key 5 Thesaurus
Key 6 Validation
Key 7 Default
Value Strict