Skip to Content

mvSQL Runtime Function - CHANGED()

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.

Remarks

The CHANGED() function was added in Vinyl 3.3.

Examples

CHANGED('Price')

Returns

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