Lookup (type, value)

Finds a row in the List of Values table (S_LST_OF_VAL) where the type column matches the type argument and the value column matches the value argument. The function returns the value of the ORDER_BY column for that row.

For example:

Lookup ("MR_MS", "Ms.")

returns "2".

LookupExpr (type, value_expr)

Searches the rows in the List of Values table (S_LST_OF_VAL) where the TYPE column matches the type argument. LookupExpr evaluates the contents of the VALUE column treated as an expression. Returns the value of the ORDER_BY column for the first row for which the expression evaluates to TRUE.

For example:

LookupExpr ("MR_MS", "M*")

returns "1".

LookupName (type, display_name)

Finds a row in the List of Values table (S_LST_OF_VAL) where the type column matches the type argument and the display value column matches the display_value argument. The function returns the language independent code.

For example:

LookupName ("MR_MS", "Ms.")

returns "Ms."

ParentFieldValue (field_name)

The value of the field_name field in the parent business component. The result does not change if the parent row is updated. The parent business component field must be exported by using Link Specification.

For example: for the Opportunity business component

ParentFieldValue("Account")

returns "Name".

FieldValue (field_name)

Return value of field in the business component as a string.

For example: for Contacts business component for Henry Kim.

For example:

FieldValue ("Last Name")

returns "Kim".

LookupValue (type, lang_ind_code)

Finds a row in the List of Values table (S_LST_OF_VAL) where the type column matches the type argument and the Language Independent Code column matches the language independent code argument. The function returns the display value.

For example:

LookupValue ("MR_MS", "Ms.")

returns "Ms."