The following steps show you how to insert or apply an ESQL function
using the Compose Mapping Expression editor.
From the Message Flow Mapping editor Overview, select the Target
Value that you want to edit. A small box appears at the
end of the row.
Click the box at the end of the row to open the Compose Mapping
Expression editor. Alternatively, from the Outline view, select
the value you wish to edit and right-click. Select Edit
Mapping from the pop-up menu and the Compose Mapping Expression
editor appears.
In the top view of the Compose Mapping Expression editor, select
the value to which you want to apply the function, or position the cursor
where you want to add the function.
Select ESQL Functions from the drop-down list of functions.
Click the small box to the right of the function type list. A list of all globally defined functions in the workspace appears.
Select a function from the list.
Drag and drop the selected function onto the value or position
selected in step 3. If you drop the function onto a selected
value, that value is placed into the selected function at the appropriate
position. If you drop the function onto a selected position, the function
is placed there ready for you to add the necessary values into that function.
Note: When an ESQL function is selected, you must specify a project
reference to the project that contains the function. If the function has been
declared under a broker schema other than the default, fully qualify the function
with its schema name.