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.

Last updated
Was this helpful?