# N (Field Name) Operand

Updated: 11/30/2021, 7:00:45 PM
Created: 11/30/2021, 7:00:45 PM
Last Updated By: Jake Tuttle
Read Time: 2 minute(s)

Tags: field operand jql

# Description

References another field defined by name in the same dictionary or found in one of the default dictionaries. It takes the general form:

N(field-name){R{R}}
1

where:

  • field-name is the name of another field defined in the same dictionary or found in the list of default dictionaries (see the JBCDEFDICTS environment variable).
  • R specifies that the value obtained from this field is to be applied repeatedly for each multivalue not present in a corresponding part of the calculation.
  • RR specifies that the value obtained from this field is to be applied repeatedly for each subvalue not present in a corresponding part of the calculation.

Any pre-process conversion codes in the specified field-name, including any further N(field-name) constructs are processed as part of the conversion code. N(field-name) constructs can be nested to 30 levels. The number of levels is restricted to prevent infinite processing loops. For example:

TEST1
008 A;N(TEST2)
1
2
TEST2
008 A;N(TEST1)
1
2

# Note

If the data definition record of the specified field contains field 8 pre-process conversion codes, these are applied before the value(s) are returned.

# Examples

A;N(S.CODE)
1

Returns the value stored in the field defined by S.CODE.

A;N(A.VALUE) + N(B.VALUE)R
1

For each multivalue in the field defined by A.VALUE, the system also obtains the corresponding value in B.VALUE and adds it. If A.VALUE returns 1]7 and B.VALUE returns 5, the result would be two values of 6 and 12 respectively.

A;N(A.VALUE) + N(B.VALUE)RR
1

For each subvalue in the field defined by A.VALUE, the system also obtains the corresponding value in B.VALUE and adds it. If A.VALUE returns 1\2\3]7 and B.VALUE returns 5, the result would be four values of 6, 7, 8 and 12 respectively.

Back to A-Corelatives