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