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-name>)

Parameters

column-name

mvSQL column name as a string.

Supports the following syntaxes:

• 'Column' - Single-part name. Example: '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