You are viewing content for 5.1 | 5.0 | 4.9 | 4.8 | 4.7 | 4.6 | 4.5 | 4.4 | 4.3 | Previous Releases


lookup

Returns a value from a table using primary key values.

Syntax

lookup(result lookup field, primary key field 1, primary key value 1, primary key field 2, primary key value 2, ....., default value)

Parameters

  • rlf : result lookup field
  • pkfN : primary key field N
  • pkvN : primary key value N
  • default :

Description

lookup fetches a value from a table using primary key values (pkv). The first parameter is the field value to be returned, while the remaining parameters are the table primary-key fields (pkf) and their respective values. The last parameter takes in the default value, which could be through a presentation variable.

See Also


© Incorta, Inc. All Rights Reserved.