List of values management

Users can specify a drop-down list of pre-defined values for both Table and Filter portlets. This pre-defined list is called a list of values. When used, the list of values will limit what a user can enter in a specific field.

To add a new list of values, go to Settings then Lists of Values. Click the Manage button.

Click the + icon to add a new list of values, then select the data source:

• Database: add name, connector and select statement.

• Workflow: create a workflow with output and connect it to the list of values using the drop-down list. The workflow can also be created and connected directly from the list of values by clicking New - Add a name - Create.

Click execute, add the text and value columns, then save.

• Text column: the value which will be shown in the drop down when using the list of values.

• Value column: the value which will be sent as the filter value

To edit an existing list of values, just click on the list of values in question and edit.