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
  • DateTime

Note

The datatype parameter is optional by default. If the Require Function Type Parameter option is enabled in the data source's Advanced Settings, the parameter becomes required. This is useful when deploying applications across different database types.

Returns

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

Examples

GENERATED('OrderId')

Returns

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