Generated() mvSQL runtime function in Jitterbit App Builder

Summary

Retrieve a generated value during the Event by the business engine.

Syntax

GENERATED(<column-identifier>, [<datatype>])

Parameters

column-identifier

mvSQL column identifier as a string.

Supports the following syntaxes:

• 'Column' - Single-part identifier. Example: 'OrderId'
• 'Table.Column' - Multi-part identifier. Disambiguates columns in separate tables that share the same name. (Example: 'Order.Id'.)
• '"Column"' - Delimited identifier, single- or multi-part. Escape special characters in table or column names. (Example: "Sales Order"."Sales Order No".)

datatype

Data type, string is default, optional. Supported datatypes:

• String (default)
• Numeric
• UUID
• Boolean
• DateTime

Returns

A value of datatype datatype, or NULL if column-identifier references an unavailable column.

Examples

GENERATED('OrderId')

Returns

0be1cfe8-990d-4553-b0a9-0f7eedea3560