Configure Results Fields

This page is accessed via Configuration and Administration > User Configuration > Screen Set Manager. Create or edit a record and go to the Results tab. Click the More button on a row.

Use this page to configure the fields on the Results page.

• Display as Link: Select this check box if you want the text to appear as a link when viewed in the finder results. In order to appear in the finder results, the link must pass the security limits set by the glog.web.security.url.<protocol>.trustedDomain property.
• Field Name: Shows the translated column name.
• Result Grid Section: Options are Static or Scroll. Determines if a column is Fixed and always appears on the results page or if the column will scroll. The ID column is always fixed.
• Precision: Allows you to determine how many fractional digits are displayed.
  
  For database fields, the field is defaulted with the type's default precision or, if defined, the UOM property value.
  
  For derived fields, it is defaulted with the field's defined precision. If the field is cleared, the system will use this precision. If the value equals the default precision, the value will not be saved. Otherwise, the value entered will be the precision used on the result page. This is for all field types except for currency.
  
  A currency's precision can be set using a currency-specific property or a global currency property. Since each currency can have a different precision, the precision field will initially show as empty. When empty it will use the property value. If a property value does not exist, then it will use the default currency precision or field precision (whichever is applicable). This value also affects inline editing and mass update. Note that these default values can be overridden with the precision property.
  
  The default precisions are:
• • Integer, Long: 0
  • Duration, Distance, Length, Speed: 1
  • Currency, Weight, Volume: 2
  • Double, BigDecimal, Temperature: 3
• Total: Determines if the column is to be totaled. Note: For Duration fields the total is in hours only.
• Query Name: Only change this field if the link on the Results screen is not working. Contact Support to find out what query is appropriate to use. For example, the query to make a Bill link work is BILL_INVOICE.
• Allow Mixed Case: When adding text, the text is not forced to be upper-case. This option is only available for the Field Type of Text. If both this option and the Allow Mixed Case option on the Search tab of the Screen Set Manager are selected, Allowed Mixed Case on the Search tab takes precedence over this one.
• Min Value and Max Value: Specify the minimum and maximum values for a number field. These fields can include negative numbers.

Edit Options

• Allow Search, View, New: Use these options to control the display of the Search, View, and New icons next to a field.
• Constraining: Allows the user to determine if empty values are allowed when a cell in the column is edited. Not available for Boolean or Indicator field types. Disabled for columns that are constrained.
• Drop List: Use this option to display a drop list for a field that provides specific default choices (usually by ID) based on data in the Oracle Transportation Management database. You cannot limit or define the values in the list. If you leave this option off, the field displays as a Power Data field with the Search, View, and New icons.
• Drop List with Description: Use this option to display a drop list that includes a description (if defined) in addition to an ID. For example, you can add the Package Item ID field and display only the ID (Drop List only option mentioned above) or the ID and the package item Name (by checking this option) in the list.
• Editable: Selecting the Editable check box allows a field to be editable using inline edit and mass update. Inline edit functionality differs depending if you are working the refreshed OTM UI or the Workbench UI.

Note: Most fields containing primary keys (PKs) will not have the Editable option available. Do not select the Editable option for any fields that are primary keys.

• Fixed Drop List: Use this option to create a specific list of values that limit the valid choices for a field. For example, there can be many values for a field based on the data in the database, but you may want to limit the user to choosing less than what is defined. If you do not use this option, Oracle Transportation Management displays the standard text field format appended with conditional operators (Begins With, Same As, etc.)
  
  When you choose this field option, you are asked to provide the database Values and their corresponding Display label. For example, the database values for the Perspective field are B and S but the display labels that appear to the user are Buy and Sell respectively.

1. 1. Enter the database Value followed by its corresponding Display label and click Add Option.
   2. Repeat step 1 to add more records.
   3. Click Save.

Workbench Options

• Include in Hover Text: Use this option to display the text for this field in the hover details popup on a map or a Gantt chart component of the workbench layout.

Parameter Criteria

If a derived field is defined with parameters by a programmer, this section then appears. Use this section to set parameter values that allow you to further filter fields. These parameters work in the same manner as defining screen set default criteria. A field can have multiple parameters or can have the same parameter added multiple times.