SAP Online Help 07.09.2004
SAP NetWeaver Visual Composer: User Guide 145
Adding Operators
Use
You may add different types of data operators to your UI logic in order to manipulate the data
returned from the data service before it is displayed in your iView. The available operators,
displayed in the Elements task panel, are:
Filter
Applies a specific filter to a selected field or fields. For example, you
may wish to filter a list of employee names to display only those
surnames that begin with a, b, c or d. In this case, your filter could
be: [a-d]*.
Sort
Automatically sorts the data according to the field(s) you select. For
example, you may wish to filter an international list of banks
according to country, from A to Z. In this case, the list might start
with all banks located in Argentina, then all banks listed in Australia,
Bolivia and so on.
Be aware that users can sort table data in ascending or
descending order at runtime, using the sort icons in the
column headers. These icons are also shown in Preview
mode (see Previewing the iView [Page 176]).
Sigma
(Aggregate
Data)
Outputs to a form a single record that is an aggregate value of the
records.
Top
Returns a specific number of records that fall at the top of the full
range of returned records.
Bottom
Returns a specific number of records that fall at the bottom of the
full range of returned records.
Distinct
Omits records that contain duplicate data in the selected fields. For
example, if Ben Smith, John Smith and Ralph Smith are listed in a
New Customers table, and the Surname field is defined as Distinct,
Ben Smith will be taken as the only record of the three.
Procedure
...
1. Drag out from the output port of the data service and from the context menu, choose
the relevant operator.
The context menu provides commonly used options. If the output is a single record,
operators will not be displayed in the context menu at all. You will need to drag the
operator from the Elements task panel.
If you are adding an operator to an existing flow, and a connection between the data
service and the UI component has already been defined, first right-click the connecting
line, and from the context menu choose Delete. Then add the operator between them.
2. From the output port of the operator, drag out to complete the connection with the input
port of the UI component. If none exists, drag out from the output port of the operator,
and from the context menu, choose the UI component in which you want to display the
data (for example, a table view).
3. Double-click the operator to display a list of fields in the Fields task panel, and in the
Define Fields list, define the operator as follows:
