For a description of the version of ESQL supported by the service flow project tools see ESQL reference.
Do not use the flow ESQL editor except to edit .esql files created in an earlier level of the service flow project tools (see Flow ESQL editor).
The Edit Expression window has the following features:
Type the ESQL expression that you want to use into this field.
The ESQL expression that you type into the Expression input field is checked for ESQL validity as you type it in.
If an error is found then an informative context-sensitive error message is displayed in the top pane of the window.
Adding a message to this pane (for example msg_ACCOUNTINFO) causes quick references to the message and its elements to be added to the content assist menu. (Continuing the example above, quick references to msg_ACCOUNTINFO.userName, msg_ACCOUNTINFO.department, and so on are added to the content assist menu.)
To add a message to the Messages in scope pane:
Click Add. The Select Message window opens.
In the Select Message window:
Select a message to add.
Click OK.
Quick references to the selected message and its elements are added to the window's content assist menu (see Content assist).
The content assist menu is a context-sensitive list of references to the ESQL operations and functions that are valid given the current location of the input cursor.
To use the content assist menu:
When the input cursor is visible in the Expression input field press Ctrl-Space to open the content-assist menu.
If you have not already done so move the input cursor to the location in the Expression input field at which you want to insert something.
In the content assist menu select the operator, function, or message element that you want to insert at this point in the expression.
The selected item is inserted into the Expression input field.