Data expressions

Data expressions are a powerful text manipulation language used in AVEVA Registers Gateway for the following purposes:

• Register configuration (ValueExpression, IDExpression, ClassExpression)

• Consolidation rules (attribute value manipulation)

• Gateway pipeline configuration (variable evaluation)

• SQL pre-processing for reports

Basic syntax

Expression delimiter: All expressions must be wrapped in {{ ... }}.

Example: {{ @[FieldName].trim.toUpper }}

Field references

• @[Field Name]: Reference a field from the current record (supports spaces in name)

• @FieldName: Reference a field without spaces

• $[attr.value]: Current attribute value (in column-level expressions)

• $[attr.name]: Current attribute name

• $[this.id]: Current object ID

• $[this.name]: Current object name

• $[this.class]: Current object class

• $[#nomenclature]: Current nomenclature

• $[data-context-id]: Current data context ID

Important notes

• Function names are case-insensitive

• Functions can be chained: value.Function1().Function2()

• Multiple calling styles supported: value.Function(), Function(value), or value.Function

• Conditions use: if ... then ... else if ... then ... else ...