Compose Data Insert Expression editor

The Compose Data Insert Expression editor is used to add value to the data insert mappings already defined in the Mapping view. The editor allows you to define more clearly how the values should be assigned and manipulated. You can also add other fields and apply different built-in and user-defined functions where required.

The editor is available in the Broker Application Development perspective; it is launched when you double-click on a Target value field in the Overview view.

Compose Data Insert Expression editor views

General Layout

Beneath the Mapping Details section at the top of the window there is a field called Mapping that shows the mapping information currently being edited. Directly beneath that is another field called Value of target field where the drop-down list allows you to select one of the targets in order to supply a target expression.

Input area

This contains the target value, or values, for the currently selected Value of target field and can be manipulated using the editor tools described below.

Operator buttons

The buttons on the right side of the screen contain the operators that can be inserted to the input area described above. Position the cursor where you want the operator inserted and click on the appropriate button. The chosen operator is placed at the cursor position.

Fields drop-down list

There are two drop-down lists available towards the bottom of the panel. The drop-down on the left by default shows Source fields. By clicking on the drop-down arrow, Output fields can also be selected. When the button immediately to the right of the drop-down button is clicked, a list of Source or Target fields is displayed. These can be selected and then dragged to their required position in the box above.

Functions drop-down list

The right-hand drop-down list by default shows String Functions. By clicking on the drop-down arrow, other function types can also be selected. Clicking on the arrow to the right shows all the functions available for the function type selected. To use one of these functions you can first highlight the field or fields to which you want to apply the function, select the function you want to use, and then drag and drop it onto the highlighted fields. Alternatively you can simply drag and drop the function where you want it and complete the necessary fields later.

Compose Data Insert expression editor toolbar

The Compose Data Insert Expression editor does not provide any additional icons and actions on the toolbar.

Related tasks
Developing mappings