Expression Components | Description |
Operators | Expression operators are used to compute values, for example, with + or -. Operators contain one or two arguments. The supported operators are: NOT, AND, OR, <=, >, <, <>, >=, =, +, *, -, /, and function calls |
Names | Valid syntax for names is: [ {namespaceURI} | prefix: ] name Examples: "customer", "{http://biz.com}customer", "biz:customer" |
Paths | Paths can be used to refer to hierarchical elements of input parameters. Paths are names separated by slashes (/). |
Literal Values | Literal values for use in expressions include: • boolean: true | false • integer:[0-9]+ • nil: null • string: 'text' • decimal: [0-9]+.[0-9]* • hexadecimal: 0x[0-9a-f]* • datetime:yyyy-mm-dd [t-hh:mm]|z] |
Function Calls | The Transformation Editor makes use of the following categories of functions: • Canonical—A function type that can be used regardless of the target language. • SQL—A function type that can be used only within SQL code. Queries can be generated into SQL. Use the sql: prefix to specify a SQL function in an expression. • XQuery—A function type that can be used only within XQuery code. Most operators are generated into XQuery. Use the xquery: prefix to specify a XQuery function in an expression. • Custom—A function type that is defined as custom within TDV. Use the custom: prefix to specify a custom function in an expression. The following canonical functions are available for use within expressions: • Aggregate: AVG, MIN, MAX, SUM, COUNT • Character: CONCAT, SUBSTRING, UPPER, LOWER, LENGTH, TRANSLATE, REPLACE, MATCHES, CHARACTER_LENGTH • Numeric: ABS, CEIL, FLOOR, ROUND • Date: CURRENT_DATE, CURRENT_TIME |