MultiField
The MULTIFIELD math variable is used to access multifield values (using INDEX as an attribute) in Screen Math and Math sections.
The INDEX attribute can be any integer value ranging from 0-99. When the INDEX attribute is equal to 0, the first instance of a multifield will be retrieved. Each additional instance of a multifield will be accessed by incrementing the INDEX value in a subsequent math variable. A math variable that is configured with an INDEX greater than the number of instances of the multifield selected on the activity will result in the value of the math variable being equal to null. For math variables that are data type STRING or DATE, null is a valid value and no error will be returned. For math variables that are data type DECIMAL or INTEGER null is not a valid value and a system error will be returned, unless a default value is specified using configuration. A math variable that is configured with the TYPE equal to MULTIFIELD, but has no INDEX attribute specified will result in a code-generated system error.
Field Math Variable in Palette
Note: For a comprehensive explanation of the characteristics of this math variable, refer to the XML Configuration Guide in the Help menu of the Rules Palette.
Define the Field Math Variable
Drag and drop the MultiField Math variable from the Palette window onto the Math Pane. Enter the following information for the math variable:
-
Type a Name in the Name field. This is required.
-
The data types are Activity, BigText, Boolean, Date, Decimal, Integer, Map, Object, Text and XML. This field is required.
-
Make sure variable type is defined as MULTIFIELD. This is required.
- Specify an index. This specifies the particular instance of the multifield to access.
-
Select Yes or No from the Log field. The default is No. This is an optional field.
- Round offers the options of Yes or No. Round is only enabled if you select the Decimal in the data type property. If you would like to round the Decimal, select Yes. Enter the number of decimal places to round the result value. Note: When the data type of Decimal is selected, the default value for Round is set to No. You must change the selection of the radio button to Yes if you wish to round.
-
Default is used for a Decimal or Integer value so the system will not return a null value. For example, the default for an Integer data type could be -999999999.
- MultiField is the name of the MultiField you wish to retrieve. Type in the Name of the field.
Check the transaction in to save the information to the database.
Copyright © 2009, 2014, Oracle and/or its affiliates. All rights reserved. Legal Notices