Valuesets
A Valueset is just a table of data with rows and columns. The main purpose of a Valueset is to be used for lookups performed by Rules.
List View
Clicking on the Valueset folder in the Project Explorer opens the Valueset list.
This screen provides a summary of the Valuesets.
General Tab
This tab has three fields, to record the Name, Description and Comments about the Valueset.
The Name is the only mandatory field, but as with Description and Comments fields elsewhere in the Studio, it is good practice to use these to record additional informative details about the migration mapping for other users.
Definition Tab
This tab allows you to define two different aspects of the Valueset. First you must define the name and datatype of the columns of the Valueset and - secondly - you must specify the Type to determine where the data content of the Valueset is going to come from.
For the second part - where does data come from - you have these options:
| Type | Description |
| Static | The data in the Valueset is typed directly in Studio. |
| Dynamic | The data is not typed in Studio, instead you provide the parameters necessary for Studio (and later the runtime) to fetch the data from some functionality external to Hopp. This is an extension point of Hopp, and it enables the creation of an installation-specific extension to, for instance, pull Valuesets out of the Target System. This in turn enables Hopp to perform high quality validation based on up-to-data data in the Target System itself. Out-of-the-box extensions provided with Hopp can retrieve data for dynamic Valuesets from Excel spreadsheets. |
| Translation | A Valueset marked as translation will automatically appear in the Portal web application allowing users in the Source or Target businesses to enter the data into the Valueset. This is a common way to get your users to supply the values to translate for instance code values from the Source System into code values in the Target System. |
Data Tab
The appearance of this tab is dependant on the Type selected on the Definition tab.
Static
For static valuesets, the values are entered directly on this screen.
Dynamic
For the dynamic Valuesets, data is in the end provided by an extension that lives outside Hopp. Hopp does not really know anything about this extension, only that it complies with an interface published by Hopp. This is a very clear and sharp separation that makes it possible to create installation specific extensions to get data for dynamic Valuesets, for instance from inside the Target system.
This screen allows you to enter the Parameter values required by the extension, which must be defined as a Valueset Provider.
Translation
This screen allows you to specify how a Valueset will behave on the Portal.
A Partition field must be selected. All of the other fields are optional.