Lookup Table builder input for the Data Service data typeAdded by IBM on August 31, 2010 | Version 1 (Original)
|The Lookup Table builder takes the following inputs when you select the data source Data Service.
The Lookup Table builder takes the following inputs when you select the data source Data Service
- General inputs
- Additional Data Definition
|Name ||Enter a name for this builder call. IBM® WebSphere® Portlet Factory Designer displays this name in the builder call list.|
Note: The name must begin with a letter or an underscore and contain only letters, digits, and underscores. This restriction allows the builder to use the Name input to build additional WebApp artifacts that implement the core of this builder's runtime functionality.
|Data Source|| Select the type of data element you want to query. You can select: |
Choose this source to query data from methods exposed from service consumer builder calls.
|Data Service||This input is displayed when the Data Service data type is enabled. |
Select a method exposed from service consumer builder calls using the Select Action dialog.
|Value Tag ||Enter the name (or, in the case of an XML variable, the node name) of the column to use to represent the value element. |
Note: If your query returns more than two columns, use this input to explicitly name the value column.
|Label Tag ||Enter the name (or, in the case of an XML variable, the node name) of the column to use to represent the label element.|
Note: If your query returns more than two columns, use this input to explicitly name the label column.
|Refresh Interval (secs) ||Enter the time in seconds that Lookup Table builder data is to be retained in the cache. |
Entering a value here enables caching and improves performance. This is generally a good idea if a large enough value is used to prevent unnecessary cache refreshes. A value of 300 seconds is usually appropriate in most applications.
Additional Data Definition
|Get Data From ||Identifies the source of data. You can choose: |
To get data from Additional Pairs table.XML Data
To get data from an XML type variable. This choice is useful if there is a default set of labels and values that should appear in a number of select lists.
|Add a blank selection||Select this option to provide a blank selection for optional fields in a form where the user does not need to provide a specific value provided by the data set.|
|Additional Pairs ||Specify any additional label and value pairs to be included in the lookup table results. (You typically do this to allow development to proceed while the database is under construction.) |
A label to be included in the ResultSet.Value
A value to be included in the ResultSetCollision Resolution
This choice allows you to handle the situation that can occur if a value and label pair that you specify is identical to one already contained in the data. When this occurs, select Use Original Value to use the pair contained in the original data. Select Use this Value to use the pair that you specified in the table.
|Table Position ||Specifies the location of additional pairs that are in the XML output of this builder. The choices are: |
The default. Additional data pairs placed in front of existing pairs in the XML stream.In Back
Additional data pairs placed in back of existing pairs in the XML stream.
|Parent Tag ||Specify the name of an XML element used to contain additional pairs in the table. Default element name is <UserAddition>.|
|Label/Value Filter Mode ||Specify how XML nodes are to be filtered. You typically do this if the rows in your XML are not identical in terms of label and value content. |
You can choose:
Use elements with both label and value elements
To use elements with sub-elements that match the chosen Label and Value inputs.None: use all elements
Use all the data.
Parent topic: Lookup Table builder inputs: wpf7