Transform Aggregate builder inputsAdded by IBM on June 28, 2011 | Version 1 (Original)
|This topic describes the inputs for the Transform Aggregate builder.
This topic describes the inputs for the Transform Aggregate builder.
- Data to Transform
- Source Schema
- Aggregate Options
- Class Generation
Table 1. General inputs
|Name||Required. Enter a name for this builder call. The WebSphere® Portlet Factory Designer displays this name in the builder call list.|
Data to Transform
Table 2. Data to Transform inputs
|Apply Transform To||Specify one of the following options to determine how the transform is to be applied to the data. |
Target Operation Results
The target operation is invoked and the transform operation is applied to the results. The data service that this builder creates has inputs that are passed through to the target operation.Target Operation Inputs
The transform operation is applied to the inputs of the data service that this builder creates. The target operation is invoked with the transformed inputs. The results of the created data service are passed through from the target operation.Variable/Reference
The data service that this builder creates has no inputs. It transforms the data provided by the variable, reference, or other data service that you indicate and returns the transformed results. The Source Data input is made available.
|Target Operation||Required. Specify the target data service to which the transform is applied. |
This input is available if the Apply Transform To input is set to either Target Operation Results or Target Operation Inputs.
|Source Data||Required. Specify either a variable, method, or a data service. |
This input is available if the Apply Transform To input is set to Variable/Reference.
|Preserve Source Data||Set this input to have the builder copy the source data before it begins the transform. Clear this input to allow the builder to overwrite the source data. Overwriting can improve performance. |
Table 3. Source Schema input
|Source Schema||Specify an existing schema type in the WebApp. |
This input is available if the Source Data input does not define a schema type. If the Apply Transform To input is set to Target Operation Inputs, this input defines the schema type for the inputs to the data service that this builder creates.
Table 4. Aggregate Options inputs
|Repeating Element to Aggregate||Required. Specify the element from the data to which the aggregation is to be applied. |
|Aggregate Operations||Specify the operations.|
Specify the source element value to be aggregated. Target
Specify the location in the new summary aggregate row in which the results of the operation are to be written.
If this value is blank, the result of the aggregation is written to the element specified in Element.
Specify the aggregate operation as one of the supported standard operations or as the name of a Java class that extends the following class.
Specify an argument for the aggregate operation specified in Operation
. The following aggregate operations do not take an argument: count, distinct, first, last, maximum, and minimum.
The aggregate operations average, product, and sum take a Java number format expression to use for formatting the result, for example, #,##0.00.
The concat operation takes the separator string to use between values, for example, : or /.
The constant operation takes, as a text string, the value to insert.
The basis for the comparison. Click in the text area to display the pull-down list.
Case Sensitive String
- lower case and upper case characters do not matchCase Insensitive String
- lower case and upper case characters matchNumber
- treat elements as numeric stringsDate
- treat elements as calendar dates. In Date Format, specify the format to be used.
Specify the format of the date to be used. This input is applicable only if Date is selected under Comparison Type.
|Remove Row Elements||Specify whether to remove the data rows from the result data and leave only the new summary aggregate row. |
Table 5. Class Generation inputs
|Generate LJO||This button is active if all required inputs are specified. Click to generate a Java™ class with the name of the builder and having methods based on the builder inputs. |
|Specify the name of the Java class that provides the implementation for this transform. ||Specify the name of the Java class that provides the implementation for this transform. |
Parent topic: Transform Aggregate builder