1. Home
  2. /
  3. Panel Help
  4. /
  5. Distribution
  6. /
  7. Work with item attr...

Work with item attr validation tables (DIR05501)

Related topics

In this table you define the validation table types that are valid for the item attribute search functionality. In addition, you define the values (for validation types of Short alphanumeric and Long alphanumeric table types) that will be valid for entry/selection for the fields that are defined in Item attribute templates. This controls the entry of values in those types of fields defined in Item attribute templates. Per Template field of those types (in Work with item attribute templates), you assign the code from this table that is to be valid. When you connect an Item attribute template to an item in the Item file, (and the end-user ultimately uses Attribute search mode to look up items), only the values held in this table for the connected Validation table code will be valid for entry/selection.

For Numeric and Date related validation types, you control the data entry of values via the Value range fields in the Item attribute template.

For File related validation types, you are able to connect a phyiscal file and the field for which you want to perform an attribute search, thereby being able to search for the values connected to that file/field. An example of this is the Signature file for the Signature field. The signature entered as a search attribute in Attribute search must exist in the file/field. Per Template field (in Work with item attribute templates), you assign the code from this table that is to be valid.

For Program related validation types, there may be data that you want to be able to perform a search on that does not exist in one specific file. Instead, you need to validate the data from several files. For this type of validation, you need to write a program that selects items holding a specific attribute.

Options

Values Select this option to work with the values that will be valid for entry/selection for Short alphanumeric and Long alphanumeric related fields that are defined in the Item attribute templates.

Selection fields

Table
This column lists the existing table codes.

Type
This column displays the panel value for the validation table type denoting what type of data is allowed.

Valid validation table types are:

Type Description
B Short alphanumeric
E Date
G File
M Long alphanumeric
O Numeric
Q Program
Number of decimals
This column is only applicable for a validation table of type “Numeric”. Displays the number of decimals that will be used for validation for a validation table of type “Numeric”.
File
This column is only applicable for a validation table of type “File”. Displays the file that will be used for validation for a validation table of type “File”.
Comparison field
This column is only applicable for a validation table of type “File”. Displays the comparison field from the file that will be used for validation for a validation table of type “File”.
Program
This column is only applicable for a validation table of type “Program”. Displays the program that will be used for validation for a validation table of type “Program”.

Work with item attr validation tables (DIR05504)

Related topics

On this panel you define the validation table types that are valid for the Item attribute search functionality.

Function keys

Table
Enter a unique code to identify the table.

Type
Enter the panel value for the validation table type denoting what type of data is allowed.

Valid validation table types are:

Type Description
B Short alphanumeric
E Date
G File
M Long alphanumeric
O Numeric
Q Program
Number of decimals
This field is only applicable for a validation table of type “Numeric”. Enter the number of decimals that will be used for validation for a validation table of type “Numeric”.
File
This field is only applicable for a validation table of type “File”. Enter the file that will be used for validation for a validation table of type “File”.
Comparison field
This field is only applicable for a validation table of type “File”. Enter the comparison field from the file that will be used for validation for a validation table of type “File”.
Program
This field is only applicable for a validation table of type “Program”. Enter the program that will be used for validation for a validation table of type “Program”.

Work with item attr validation tables, Copy (DIR05505)

Related topics

Table
Displays the table code(s) you selected to copy.

New table
Enter the new table code(s) that you are creating.

Work with item attr validation tables, Deletion (DIR05508)

Related topics