You do not need to know any JavaScript to write simple expressions in WorkSpace Data Federation. In any field where you can enter an expression, you can use the expressions menu to choose the parameters, variables, logical operators, predefined functions, and input column names with which you construct your expression.
To access the expressions menu, right-click in any field that accepts expressions. Expression fields are typically in an operator’s properties dialog.
Using the submenus in the expressions menu, you can enter any of the following into an expression:
| Expressions submenu | Purpose |
|---|---|
| Global Parameters | Reference global parameters defined in this view model. |
| Columns from input elements | Reference columns in the element(s) immediately upstream. There is one “columns from” submenu for each input connected to the operator whose expression you are editing. The names of these submenus refer to the upstream operators—for example, Columns from Select1 or Columns from SalesFiguresDS. Each submenu lists the columns in the upstream operator’s result set. |
| Downstream Variables | Reference variables defined in operators downstream (that is, closer to the Result than) the current operator. |
| Operators | Add JavaScript
operators to modify your expression. If you have done any scripting or other programming, you are likely to be familiar with many of the items in the Operators submenu. The most basic arithmetic operators (+, -, *, /) are not included in the menu; they can be entered from the keyboard. |
| Data Federation Functions | Add utility functions to retrieve values from result sets or identify the user running the data service based on your view model. |
Send your feedback on this help topic to Sybase Technical Publications: pubs@sybase.com
Your comments will be sent to the technical publications staff at Sybase, Inc. For product-related issues or technical support, contact Sybase Technical Support at 1-800-8SYBASE.