See information about the latest product version
Mapping syntax
Use content assist to find the variable names for input and output objects, paths, and database elements.
Press Ctrl+Spacebar to display content assist, and use it to help you build your XPath statements and mapping expressions. Content assist provides the variable names that you need to use to reference elements in your XPath statements and expressions. The variable name assigned for the same element can vary between uses in different transforms, so always use content assist to obtain the correct variable name. Avoid copying and pasting expressions that include variable names.
- Making comparisons
- Performing arithmetic
- Creating complex conditions
- = (equals)
- != (not equals)
- > (greater than)
- >= (greater than or equal)
- < (less than)
- <= (less than or equals)
- + (plus)
- - (minus)
- * (multiply)
- div (divide)
For information about XPath syntax, see W3C XML Path Language (XPath) 2.0.
Conditional operators (or and and) are supported; these are case-sensitive.
- Message elements (defined in the schema for the input and output)
- Message assembly, comprising the properties tree and optionally the LocalEnvironment and transport headers
- Data from database tables
Database objects with names that do not conform to the XML NCName format
Some database objects have names that do not conform to the XML NCName format (for example, the name contains characters like #, or $). If the database object name is used in SQL (for example, in the where clause of the Select transform), no action is required. If the database object is used in XPath (for example, in a Custom transform or a condition), use content assist, which adds the appropriate XPath-compliant expression.