Validating Custom Column Data

When creating your user-defined queue, you have several options to make sure the queue displays the data you want to retrieve from the Eclipse system. Among these options, you can create custom validations for your queue column based an Eclipse file, control maintenance record, data list, or subroutine.

Define the following validation type and how you want it to work for your queue:

Like File Import Maintenance, the Field Validation and Field Conversion fields work together. The value or field type you have in the Field Validation field, determines what you need to enter in the Field Conversion field. Similar to a MS Excel cell format, if you select in the Field Validation field for the value to be Numeric, then you use the Field Conversion field to tell the system how you want that number to use the decimals. For example, to move the decimal to the right two places, you enter MR2. Press F10 to display a list of valid options.