Skip to main content
Mitratech Success Center

Field Selected – Validation

When a field is selected and the Validation tab is selected, the following options are displayed.

image

The Validation Type is used to define how the field value is determined to be valid. The Validation Type options are described in Table 84.

Table 84. Terminology: Data Definition Field Validation Type and Details

Term

Meaning

Use Validation lengths and values

When selected, the validation of the field value is determined by the configured validation lengths and values. The settable options change according to the field Type selected. See 
Table 85 for Text, 
Table 86 for Currency, 
Table 87 for Whole Number and
Table 88 for Date and Time.

Use Allowable values

When selected, the validation of the field value is determined by the configured entries in the Allowable Values list. If the field value is equal to a value in the Allowable Values list, it passes validation. See Table 89.

Use an expression

Use an expression – enables you to enter date and time keywords and operators to ensure the date falls within a specified range. See the option described below.

Expression to be used for validation (Indexing keywords, for example)

Enter an expression, using date and time keywords, to be used to validate the date and time field. For example, for a day accuracy field, to ensure the date is only today’s date or yesterday’s date enter:

#today [OR] #yesterday

Alternatively, for a year accuracy field, to limit dates to no earlier than 10 years ago, enter:

>#now (-10 years)

A full list of valid date and time keywords see Date and Time: Keyword Syntax.

Note: This option is used only when Use an expression is selected

The options when the field Type is set to Text are described in Table 85.

Table 85. Terminology: Data Definition Field – Validation Properties: Text

Term

Meaning

Minimum length

When selected, enter the minimum number of characters in the text string that is valid.

Maximum length

When selected, enter the maximum number of characters in the text string that is valid.

None

Leading zeroes are not removed and leading spaces are not converted to zeroes.

Strip Leading Zeroes

When selected, if the text string starts with one or more zeroes, these are removed.

Convert Leading Spaces to zeroes

When selected, if the text string starts with one or more spaces, these are converted to zeroes.

Regular Expression mask

When selected, enter a regular expression in the text box provided. Or click the button to display the Regular Expression Generator window.

The options when the field Type is set to Currency are described in Table 86.

Table 86. Terminology: Data Definition Field – Validation Properties: Currency

Term

Meaning

Minimum value

When selected, enter the minimum value for the Currency that is valid.

Maximum value

When selected, enter the maximum value for the Currency that is valid.

Non zero

When selected, only non-zero values are valid.

The options when the field Type is set to Whole Number are described in Table 87.

Table 87. Terminology: Data Definition Field – Validation Properties: Whole Number

Term

Meaning

Minimum value

When selected, enter the minimum value Whole Number that is valid.

Maximum value

When selected, enter the maximum value Whole Number that is valid.

Non zero

When selected, only non-zero values are valid.

The options when the field Type is set to Date and Time are described in Table 88.

Table 88. Terminology: Data Definition Field – Validation Properties: Date and Time

Term

Meaning

Minimum date and time

When selected, click the button and select the earliest Date and Time that is valid.

Maximum date and time

When selected, click the button and select the latest Date and Time that is valid.

The buttons available when Use allowable values is selected are described in Table 89.

Table 89. Terminology: Data Definition Field – Validation Properties: Use Allowable Values

Button

Meaning

image

Add Value. Enter the Allowable value in the text box and click the

Add Value button.

image

Edit Value. Select the Allowed value in the Allowable Values list, edit the value and click the Edit Value button.

image

Delete Value. Select the Allowable value in the Allowable Values list and click the Delete Value button.

image

Import Allowable Values.

image

Select From a text file to import the Allowable Values from a text file. Select the path and the file you want to Import to produce the Allowable Values list. (Only data from the file which is of the same Type as the field will be Imported, for example, Date and Time.)

Select From the clipboard to import the Allowable Values from the contents of the clipboard.

image

Export Allowable Values. Click Export to open a Windows directory navigation pane. Enter a name for the text file in which you want to save the allowable values and select a folder in which to save the text file. Click Save to save the text file, or Cancel to exit without exporting the allowable values to a text file.

Validation – Index Field Value Transformation

image

Caution: This feature is for advanced DataStore®DSX users.

Index Field Value Transformation is provided to enable you to manipulate data that might not pass validation. For example, consider you have a document in which the date is stored as 05072005. This, in its current state, is not a valid date. It needs to be transformed so it’s displayed as 05/07/2005.

image

Note: Transformations can be applied to Content fields only. That is, Transformations are not available for manually entered field values.

image

The options for Field Value Transformations are described in Table 90.

Table 90. Terminology: Data Definition Field Validation Field Value Transformations

Term

Meaning

New Format

Click to create a new Custom Format. The Custom Format Editor is opened.

Edit

Click to edit the selected Format. The Custom Format Editor is opened.

Delete

Click to delete the selected format.

Test Format

Enter a string in the text box beside the Test Format button. Click the Test Format button to test how the string is transformed with the transformation mask. A window is displayed indicating whether the transformation was successful. If the transformation was successful, a window is displayed showing the output string.

The options for the Custom Format Editor are described in Table 91.

Table 91. Terminology: Data Definition Field Validation Custom Format Editor

Term

Meaning

Mask to match index field

Enter a Regular Expression mask to define how the string should be split in to components. In the above date example, this would be (\d{2})(\d{2})(\d{4}).

Format to transform value

Enter the order of the components and any separators you want to use. In the above date example, this would be {0}/{1}/{2}.

String to be tested

Enter the string to be tested. In the above date example, this would be 05072005.

Test Custom Format

Click the Test Custom Format button. A window is displayed indicating whether the transformation was successful. If the transformation was successful, the output string is displayed.

  • Was this article helpful?