Skip to Content

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

Returns

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

Examples

GENERATED('OrderId')

Returns

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