Skip to Content

Changed() mvSQL runtime function in Jitterbit App Builder

Summary

Reports if a column value was modified at the start of the event. In practice, this function can be used to determine if the user changed the column value. It cannot be used to determine if a business rule changed the column value during the course of the event.

Syntax

CHANGED(<column-identifier>)

Parameters

column-identifier

mvSQL column identifier as a string.

Supports the following syntaxes:

  • 'Column' - Single-part identifier. Example: 'Price'
  • 'Table.Column' - Multi-part identifier. Disambiguates columns in separate tables that share the same name. Example: 'Products.Price'.
  • '"Column"' - Delimited identifier, single- or multi-part. Escape special characters in table or column names. Example: "Products"."Price".

Returns

Returns true or false depending on result of evaluating the column-identifier.

Examples

CHANGED('Price')

Returns

true if Price column was dirty at the start of the event, otherwise returns false